DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q61
which character function is used to return a specified portion of a character string
  • A Initcap
  • B Concat
  • C Substring
  • D Length
Answer: Option C
Q62
Which dictionary view gives the information of the tables of user
  • A All tables
  • B User tables
  • C DBA tables
  • D All the above
Answer: Option B
Q63
What is default length of the CHAR datatype
  • A 256
  • B 122
  • C 1
  • D 64
Answer: Option C
Q64
Which of the following statements from database
  • A set of tables & views
  • B set of clusters
  • C set of synonyms
  • D none of the above
Answer: Option A
Q65
Which way of accessing information in the database is easy
  • A primary key access
  • B Table access by ROWID
  • C access by foreign key
  • D none of these
Answer: Option B
Q66
Which way of accessing information in the database is easy
  • A primary key access
  • B Table access by ROWID
  • C access by foreign key
  • D none of these
Answer: Option B
Q67
Which command will remove all data from the table and not able to roll back is
  • A DELETE
  • B DROP
  • C TRUNCATE
  • D ALL THE ABOVE
Answer: Option C
Q68
When a user creates an object with out giving table-space then where it will stored
  • A system table-space
  • B Oracle table-space
  • C Oracle Error
  • D Default Table-space
Answer: Option D
Q69
Which character is used to continue the SQL* plus
  • A *
  • B /
  • C +
Answer: Option D
Q70
Assume that today is Monday of jan 2006 then what is the output of the query bellow SELECT TO CHAR (NEXT DAY(SYSDATE MONDAY,
  • A 17/01/06
  • B 17/jan/06
  • C 17-01-06
  • D 17-Jan-06
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test