DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
61. which character function is used to return a specified portion of a character string
- Initcap
- Concat
- Substring
- Length
62. Which dictionary view gives the information of the tables of user
- All tables
- User tables
- DBA tables
- All the above
64. Which of the following statements from database
- set of tables & views
- set of clusters
- set of synonyms
- none of the above
65. Which way of accessing information in the database is easy
- primary key access
- Table access by ROWID
- access by foreign key
- none of these
66. Which way of accessing information in the database is easy
- primary key access
- Table access by ROWID
- access by foreign key
- none of these
67. Which command will remove all data from the table and not able to roll back is
- DELETE
- DROP
- TRUNCATE
- ALL THE ABOVE
68. When a user creates an object with out giving table-space then where it will stored
- system table-space
- Oracle table-space
- Oracle Error
- Default Table-space
70. Assume that today is Monday of jan 2006 then what is the output of the query bellow
SELECT TO CHAR (NEXT DAY(SYSDATE MONDAY,
- 17/01/06
- 17/jan/06
- 17-01-06
- 17-Jan-06