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
Exam TypeMASTER EXAM
Authenticity9999
creatorAnirudh(39272)

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

Answer:Semi-Join


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

Answer:Project


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

Answer:Reduces


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.

Answer:Refresh


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

Answer:Constraint


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

Answer:CREATE SCHEMA


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?

Answer:SUBSTR


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

Answer:2345


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

Answer:UPDATE


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

Answer:tuple


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

Answer:update


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

Answer:domain