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