get the app get the app       get the app       get the app

Database Managment System QUESTIONS

Exam NameDatabase Managment System QUESTIONS
DescriptionDatabase Managment System QUESTIONS and Answers exams contains the questions from various competitive exams.These questions are the part of previous year paper.These kind of questions would be helpful in preparing for exams like IAS, PCS, UPSC, NDA, CDS SSC, RRB, PSC, IBPS

Back to Parent Category
Create QuestionPDF  
Question: ………………….. operator is basically a join followed by a project on the attributes of first relation.


Question: Which of the following is not a binary operator in relational algebra?


Question: Centralizing the integrity checking directly under the DBMS ………….. Duplication and ensures the consistency and validity of the database.


Question: Which of the following is/are the DDL statements?

Answer:All of the above

Question: In snapshot, …………………. clause tells oracle how long to wait between refreshes.


Question: ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.


Question: In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?


Question: In SQL, the CREATE TABLESPACE is used

Answer:to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace.

Question: Which character function can be used to return a specified portion of a character string?


Question: Which of the following is TRUE for the System Variable $date$?

Answer:Can be assigned to any field only during design time.

Question: What are the different events in Triggers?

Answer:Insert, Update, Delete

Question: Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

Answer:Data Definition Language

Question: The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc','b'), 4) FROM EMP; prints


Question: Which of the following SQL command can be used to modify existing data in a database table?


Question: When SQL statements are embedded inside 3GL, we call such a program as ..........

Answer:embedded SQL

Question: The RDBMS terminology for a row is


Question: To change column value in a table the ......... command can be used.


Question: The full form of DDL is

Answer:Data Definition Language

Question: To pass on granted privileges to other user the ...... clause is used

Answer:grant option

Question: A set of possible data values is called