MCQ 1 A file manipulation command that extracts some of the records from a file is called

(A) SELECT (B) PROJECT (C) JOIN (D) PRODUCT

MCQ 2 The _______________ operator is used to compare a value to a list of literals values that have been specified.

(A) BETWEEN (B) ANY (C) IN (D) ALL

MCQ 3 A logical schema

(A) is the entire database (B) is a standard way of organising information into an accessible part (C) describe how data is actually stored on disk (D) None of the these

MCQ 4 A B-tree of order m has maximum of _________________ children.

(A) m + 1 (B) m (C) m − 1 (D) m/2

MCQ 5 The RDBMS terminology for a row is

(A) tuple (B) relation (C) attribute (D) degree

MCQ 6 Which one of the following is not true for a view

(A) A view is derived from other tables (B) A view is a virtual table (C) A view definition is permanently stored as part of the database (D) The view never contains derived columns

MCQ 7 The method of access which uses key transformation is known as

(A) Direct (B) Hash (C) Random (D) Sequential

MCQ 8 Correct SQL query to delete a column from a table in SQL Server database

(A) ALTER TABLE tablename, DROP COLUMN columnName (B) DROP COLUMN columnName FROM table name (C) DELETE columnName FROM tableName (D) None of the above

MCQ 9 SQL Select statement to retrieve unique record from a table is

(A) SELECT DISTINCT (B) SELECT UNIQUE (C) SELECT UNION ALL (D) SELECT UNION

MCQ 10 With SQL, how do you select all the columns from a table named "Persons"?

(A) SELECT Persons (B) SELECT [all] FROM Persons (C) SELECT * FROM Persons (D) SELECT *.Persons

MCQ 11 Which SQL statement is used to extract data from a database?

(A) SELECT (B) GET (C) INSERT (D) EXTRACT

MCQ 12 If there is more than one key for relation schema in DBMS then each key in relation schema is classified as ______________.

(A) Prime key (B) Super key (C) Candidate key (D) Primary key

MCQ 13 Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

(A) Candidate key (B) Primary Key (C) Super Key (D) Sub Key

MCQ 14 how do you select all the records from a table named "records" where the value of the column "FirstName" is "Rajiv"?

(A) SELECT [all] FROM records WHERE FirstName='Rajiv' (B) SELECT * FROM records WHERE FirstName='Rajiv' (C) SELECT * FROM records WHERE FirstName<>'Rajiv' (D) SELECT [all] FROM records WHERE FirstName LIKE 'Rajiv'

MCQ 15 Which SQL statement is used to create a table in a database?

(A) CREATE TABLE (B) CREATE DATABASE TABLE (C) CREATE DB (D) CREATE DATABASE

MCQ 16 How can you return the number of records in the "records" table?

(A) SELECT NO(*) FROM records (B) SELECT LEN(*) FROM records (C) SELECT COLUMNS(*) FROM records (D) SELECT COUNT(*) FROM records

MCQ 17 How can you delete the records where the "FirstName" is "Rajiv" in the records Table?

(A) DELETE ROW FirstName='Rajiv' FROM records (B) DELETE FirstName='Rajiv' FROM records (C) DELETE FROM records WHERE FirstName = 'Rajiv' (D) DELETE FROM records and FirstName = 'Rajiv'

MCQ 18 Which SQL statement is used to return only different values?

(A) SELECT DIFFERENT (B) SELECT UNIQUE (C) SELECT DISTINCT (D) All of the above

MCQ 19 The command used to delete a particular column in a relation is ______________

(A) UPDATE TABLE (B) TRUNCATE COLUMN (C) ALTER, DROP (D) DELETE COLUMN

MCQ 20 The UNION SQL clause can be used with _____________

(A) SELECT clause only (B) DELETE and UPDATE clauses (C) UPDATE clause only (D) All of the above

MCQ 21 Which one is the correct declaration for choosing the character set other than default?

(A) Varchar(20) character set; (B) Varchar(20); (C) Varchar character set (20); (D) Varchar(20) character set utf8;

MCQ 22 Drop Table cannot be used to drop a table referenced by a ______________ constraint.

(A) Primary Key (B) Sub Key (C) Super Key (D) Foreign Key

MCQ 23 Insert into instructor values (1001, 'Rajiv Sharma', 'PHP Language', 101); What type of statement is this?

(A) Query (B) DML (C) DDL (D) Relational

MCQ 24 Which of the following is a comparison operator in SQL?

(A) BETWEEN (B) Double equal sign ( == ) (C) Single equal sign ( = ) (D) LIKE

MCQ 25 Which of the following is not a User defined function?

(A) Max() (B) Scalar Function (C) Multi-Statement Table-Valued Function (D) Inline Table-Valued Function