Database Management System Set 50

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Practice Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 50

Q1 | What is the expansion of QBE?
  • Query by Example
  • Query by Experiment
  • Question before evaluation
  • None of the above
Answer: Query by Example
Q2 | Who developed Structured English Query Language?
  • E.F. Codd
  • D. Chamberlain
  • Chris Date
  • None of the above
Answer: D. Chamberlain
Q3 | Which of the following is the first commercial RDBMS?
  • DB2
  • INGRESS
  • ORACLE
  • None of the above
Answer: None of the above
Q4 | Which of the following is IBM’s first RDBMS?
  • DB2
  • IMS
  • SQL/DS
  • None of the above
Answer: SQL/DS
Q5 | Which of the following company now known as the Oracle Corporation?
  • Stepware Inc.
  • Relational Software Inc.
  • Rational Inc.
  • Oracle Software Inc.
Answer: Relational Software Inc.
Q6 | What is the process that is done to SQL before execution, to check for proper syntaxand to optimize the request called?
  • Syntax checking
  • Performance tuning
  • Parsing
  • Optimizing
Answer: Parsing
Q7 | Which of the following is a valid SQL data type?
  • CHARACTER
  • NUMERIC
  • FLOAT
  • All of the above
Answer: All of the above
Q8 | Which of the following is not a data definition language statement?
  • CREATE
  • ALTER
  • DROP
  • SELECT
Answer: SELECT
Q9 | Which of the following is not a DCL statement?
  • GRANT
  • REVOKE
  • ROLLBACK
  • None of the above
Answer: ROLLBACK
Q10 | Which of the following is a comparison operator?
  • 0
  • LIKE
  • BETWEEN
  • All of the above
Answer: All of the above
Q11 | Which of the following consists of a row of column headings, together with zero or morerows of data values?
  • COMPOSITE INDEX
  • UNIQUE INDEX
  • TABLE
  • None of the above
Answer: TABLE
Q12 | In which of the following cases will the RDBMS specify a default value for the columnif there are no values for it?
  • NOT NULL WITH DEFAULT
  • COLUMN DEFAULT
  • NOT NULL UNIUE
  • None of the above
Answer: NOT NULL UNIUE
Q13 | Which of the following database object does not physically exist?
  • Base table
  • Index
  • View
  • None of the above
Answer: View
Q14 | How many tables can be joined to create a view?
  • 1
  • 2
  • Database dependent
  • None of the above
Answer: Database dependent
Q15 | Which of the following is a structure that provides faster access to the rows of a tablebased on the values of one or more columns?
  • Table
  • View
  • Index
  • None of the above
Answer: Index
Q16 | Which of the following index is made up of more than one column?
  • Composite index
  • Clustered index
  • Simple index
  • None of the above
Answer: Composite index
Q17 | Which of the following index can occur only one per table?
  • Distinct index
  • Unique index
  • Simple index
  • Clustered index
Answer: Unique index
Q18 | Which question corresponds best to the following query?SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2
  • Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Leave an empty line after every second line.
  • Select two columns from the COURSES table, the second one gets as title “ =PRICE”.Sort the data according to the second column, in ascending order.
  • Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order.
  • Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order
Answer: Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order.
Q19 | What is the default order of Order by clause?
  • Descending
  • Ascending
  • Random
  • None of the above
Answer: Ascending
Q20 | View the Exhibit and examine the structure of the EMPLOYEES andDEPARTMENTS tables. Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers? SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;
  • UNION
  • MINUS
  • INTERSECT
  • UNION ALL
Answer: MINUS
Q21 | View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
  • The statement would execute successfully and display all the rows in the ascending order ofDEPARTMENT_ID.
  • The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.
  • The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.
  • The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.
Answer: The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.
Q22 | Which CREATE TABLE statement is valid?
  • CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date date NOT NULL); 50
  • CREATE TABLE ord_details (ord_no NUMBER(2) UNIQUE, NOT NULL, item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL);
  • CREATE TABLE ord_details (ord_no NUMBER(2) , item_no NUMBER(3), ord_date date DEFAULT NOT NULL, CONSTRAINT ord_uq UNIQUE (ord_no), CONSTRAINT ord_pk PRIMARY KEY (ord_no));
  • CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
Answer: CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
Q23 | Pick entities from the following:I. vendor II. student III. attends IV. km/hour
  • i, ii, iii
  • i, ii, iv
  • i and ii
  • iii and iv
Answer: i and ii
Q24 | By relation cardinality we mean
  • number of items in a relationship
  • number of relationships in which an entity can appear
  • number of items in an entity
  • number of entity sets which may be related to a given entity
Answer: number of relationships in which an entity can appear
Q25 | If an entity appears in only one relationship then it is
  • a 1:1 relationship
  • a 1:N relationship
  • a N:1 relationship
  • a N:M relationship
Answer: a 1:1 relationship
Previous Next