10th IT 402 || Information Technology || Database Management System MCQ Questions!

IT 402 Database Management System   Q1. Which of the following will help to maintain the unique record in the table? a. Foreign Key b. Primary Key c. Composite Key d. Alternate Key   Q2. Which of the following field of table “Book” can act as the primary key? a. Book_number b. Subject c. price d. Author_name   Q3. When the primary key is made up of two or more columns then it is called __ primary key. a. Mixed b. Reference c. Composite d. Compost Q4. Duplicate values can be entered in the primary key. (T/F) a. True b. False Q5. A key which is referring to the primary key of another table is called _ a. Alternate Key b. Primary Key c. First Primary Key d. Foreign Key Q6. A field that is __ for each and every record is called the Primary key. a. Common b. Same c. Unique d. None of the above Q7. When data is stored, maintained, and retrieved from multiple tables then special database software are required called __ a. DBMS b. RDBMS c. Special DBMS d. All of the above Q8. Identify the Foreign Key from table “Sales” Table Client: ClientID (primary Key) client name client phone Table: Sales sales (Primary Key) ClientID Profit a. SalesID b. Profit c. Client phone d. ClientID Q9. Which of the following is not a valid field of table “Student” a. admno b.name c. fees d. salary Q10. There can be multiple primary keys in a table. (T/F) a. True b. False  Digital Documentation MCQ Questions!  Digital Spreadsheet MCQ Questions!