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