MCQ 1 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 2 Character data can be stored as ____________.

(A) Either Fixed or Variable length string (B) Variable length string (C) Fixed length string (D) None of the above

MCQ 3 Which SQL commands can be used to delete all records from the table in a sql databas

(A) Delete (B) Delete with where condition (C) TRUNCATE (D) Both A and C

MCQ 4 SQL Command to remove stored procedure SQL

(A) Remove (B) Drop (C) Delete (D) Erase

MCQ 5 Which of the following operations requires the relations to be union compatible?

(A) Union (B) Intersection (C) Difference (D) All of these

MCQ 6 How do you select all the records from a table named "records" where the value of the column "FirstName" starts with an "R"?

(A) SELECT * FROM Persons WHERE FirstName LIKE 'R%' (B) SELECT * FROM Persons WHERE FirstName='%R%' (C) SELECT * FROM Persons WHERE FirstName LIKE '%R' (D) SELECT * FROM Persons WHERE FirstName='R'

MCQ 7 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 8 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 9 The COUNT function in SQL returns the number of ______________.

(A) Values (B) Distinct values (C) Columns (D) Group by

MCQ 10 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 11 How can you insert a new record into the "records" table?

(A) INSERT INTO records VALUES ('Rajiv', 'Sharma') (B) INSERT records VALUES ('Rajiv', 'Sharma') (C) INSERT records VALUES Into ('Rajiv', 'Sharma') (D) INSERT ('Rajiv', 'Sharma') Into records

MCQ 12 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 13 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 14 Which SQL keyword is used to sort the result-set?

(A) SORT BY (B) ORDER (C) SORT (D) ORDER BY

MCQ 15 Which data type can store unstructured data in a column?

(A) CHAR (B) RAW (C) NUMERIC (D) VARCHAR

MCQ 16 The virtual table that its created by data from the result of an SQL 'Select' statement is called ______________.

(A) View (B) Transaction (C) Synonym (D) Sequence

MCQ 17 A View is in database is

(A) A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. (B) A view is a database diagram. (C) A view is a special stored procedure executed when certain event occurs. (D) All of the above

MCQ 18 Which of the group functions ignonre null values?

(A) MAX (B) COUNT (C) SUM (D) All of the above

MCQ 19 Which SQK Keyword is used to retrive a maximum value?

(A) Top (B) Most (C) Upper (D) Max

MCQ 20 Which of the following is true for TRUNCATE in SQL?

(A) It is usually slower than DELETE command (B) There is no comparison between DELETE & TRUNCATE (C) It is usually faster than DELETE command (D) None of these

MCQ 21 Difference between a primary key and a unique key?

(A) Primary key cannot be a date variable whereas unique key can be (B) Primary key can take null values but unique key cannot null values (C) You can have only one primary key whereas you can have multiple unique keys (D) None of the above

MCQ 22 If we do want to eliminate duplicates, we use the keyword _____________in the aggregate expression.

(A) Count (B) Distinct (C) Avg (D) Primary key

MCQ 23 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 24 Which of the following is not a DDL command?

(A) UPDATE (B) TRUNCATE (C) ALTER (D) None of the above

MCQ 25 Aggregate functions are functions that take a ___________ as input and return a single value.

(A) Collection of values (B) Single value (C) Double value (D) All of the above