DBMS ST Jan 2025

1. A tuple is equivalent to __________.

• Field
• Record
• File
• Database

2. Hiding the implementation details from the user is called

• Data Security
• Data Hiding
• Dat Modelling
• Data Abstraction

3. Which of the following is not a DDL command?

• Create
• Select
• Alter
• Update

4. What are SQL constraints?

• Set of rules that impose some restrictions while inserting, deleting, or updating the data in the databases.
• Set of constraints to copy the data from database tables.
• SQL commands to join to two tables.
• SQL constraints to alter data in a table.

5. SELECT *  

1. FROM instructor  

2. ORDER BY salary 

3. --This query will display the records in _____ order by salary

• Ascending

• Descending

• Error in Query

6. Primary key, if combined with a foreign key creates

• parent child relationship between the tables that connect them
• many-to-many relationship between the tables that connect them
• network model between the tables connect them

7. Which of the following is incorrect about 'views' in SQL?

• Views are virtual tables.
• Views are used to add constraints in SQL.
• Views refer to a named set of SQL statements.
• Views can be referred same way as tables.

8. Which of the following is TRUE about foreign keys?

• Tables that contain foreign keys contain columns that point to another table's primary key
• Primary key of one table could be the foreign key for another table
• Both A and B
• None of the above

9. Which one of the following refers to the "data about data"?

• Directory

• Sub-Data

• Metadata

• Warehouse

10. To which of the following the term "DBA" referred?

• 1. Data Bank Administrator

• Database Administrator

• Data Basic Administrator