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