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

Correct Answer Choice A SELECT
See Answer

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

Correct Answer Choice A BETWEEN
See Answer

MCQ 3 A logical schema

Correct Answer Choice A is the entire database
See Answer

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

Correct Answer Choice B m
See Answer


MCQ 5 The RDBMS terminology for a row is

Correct Answer Choice A tuple
See Answer

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

Correct Answer Choice C A view definition is permanently stored as part of the database
See Answer

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

Correct Answer Choice B Hash
See Answer

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

Correct Answer Choice A ALTER TABLE tablename, DROP COLUMN columnName
See Answer


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

Correct Answer Choice A SELECT DISTINCT
See Answer

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

Correct Answer Choice C SELECT * FROM Persons
See Answer

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

Correct Answer Choice A SELECT
See Answer

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

Correct Answer Choice C Candidate key
See Answer


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

Correct Answer Choice C Super Key
See Answer

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

Correct Answer Choice B SELECT * FROM records WHERE FirstName='Rajiv'
See Answer

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

Correct Answer Choice A CREATE TABLE
See Answer

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

Correct Answer Choice D SELECT COUNT(*) FROM records
See Answer


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

Correct Answer Choice C DELETE FROM records WHERE FirstName = 'Rajiv'
See Answer

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

Correct Answer Choice C SELECT DISTINCT
See Answer

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

Correct Answer Choice C ALTER, DROP
See Answer

MCQ 20 The UNION SQL clause can be used with _____________

Correct Answer Choice A SELECT clause only
See Answer


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

Correct Answer Choice D Varchar(20) character set utf8;
See Answer

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

Correct Answer Choice D Foreign Key
See Answer

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

Correct Answer Choice B DML
See Answer

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

Correct Answer Choice B Double equal sign ( == )
See Answer


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

Correct Answer Choice A Max()
See Answer

Advantages Of NCERT, CBSE & State Boards Solutions For All Subjects

  • All the NCERT Solutions have been prepared by academic experts having 10+ years of teaching experience.
  • They have prepared all the solutions in simple and easy language, so that each and every student can understand the concepts easily.
  • All the solutions have been explained step to step wise in details with better explainations.
  • Students can also use these question and answers for your assignments and in homework help.
  • All the solutions have been explained in detail and the answers have been compiled in a step-wise manner.
  • All the question and asnwers are commonly prepared according to the Latest Syllabus of Board Education and Guidelines.
  • Students can know about the various types of questions asked in the exams with the help of these solutions.

Top Course Categories