Database Concepts Quiz 0% database concepts quiz Click here - database concepts notes NameEmail 1 / 25 Which of the following is type of SQL? CTL TDL DDL 2 / 25 In a table having idno, name, fee , aadharno. which fields are candidate keys? name and fee idno and name idno and aadharno 3 / 25 What is the use of primary key? To uniquely identify records within a table To delete records from a table To search records within a table 4 / 25 In a table having three fields: idno, name and fee, which can be a primary key. idno name fee 5 / 25 What is domain? Set of values that can not be put into a particular field of a table. Set of values that can be put into a record Set of values that can be put into a particular field of a table. 6 / 25 Relation is another name of: Table Database Record 7 / 25 What is the full form of SQL Structured Questions Language Structured Query Language Structured Language 8 / 25 Which data type can be used to store date values? time date datetime 9 / 25 Which of the following data types can be used to store numeric values? char date number 10 / 25 Which of the following is a DDL statement? Insert Drop table Select 11 / 25 What is cardinality? Number of tables Number of Fields Number of records 12 / 25 What is the full form of DML? Data Making Language Data Definition Language Data Manipulation Language 13 / 25 Which of the following contains data in the form of rows and columns? Attribute Relation Database 14 / 25 What is attribute? Largest piece of information. One record of table Smallest piece of information. 15 / 25 Which of the following is fixed length data type? varchar2 varchar char 16 / 25 What is tuple? Name of table Field of table Record of table 17 / 25 Which of the following is a DML statement? Alter Select Create 18 / 25 what is degree of a table? Number of attributes. Number of records. Number of relationships. 19 / 25 what is alternate key? Candidate key which is primary key Candidate key which is not primary key 20 / 25 What is the full form of DDL? Data Definition Language Data Manipulation Language Data Dump Language 21 / 25 What is foreign key? Field whose values are derived from primary key of another table. Field whose values are not derived from primary key of another table. 22 / 25 Which of the following is an example of DBMS? MY SQL Microsoft Word Microsoft Excel 23 / 25 Update statement is a : DML Statement DDL Statement TCL statement 24 / 25 What is DBMS? software to create documents Hardware device to store Software to store and maintain data 25 / 25 What is candidate key? Fields that are capable of becoming primary key Fields that are not capable of becoming primary key Your score is 0% Restart quiz Exit Lesson tags: class 12 computer science quizes, database concepts quiz, sql quiz Database Concepts Class 12 CBSE SQL commands For class XII CBSE Back to: CBSE class 12 Computer Science notes