Question 1. The field is otherwise called as _________ of the record.
(A) Variable
(B) Data type
(C) Value
(D) Data item
Question 2. DBMS helps achieve ___________.
(A) Data independence
(B) Centralized control of data
(C) Neither A nor B
(D) Both A and B
Question 3. ………. command can be used to modify a column in a table.
(A) Update
(B) Create
(C) Alter
(D) Set
Question 4. Grant and revoke are ……. statements.
(A) DCL
(B) DDL
(C) TCL
(D) DML
Question 5. To change column value in a table the ……… command can be used.
(A) Insert
(B) Update
(C) Alter
(D) Create
Question 6. The full form of DDL is ___________.
(A) Dynamic Data Language
(B) Data Definition Language
(C) Data Derivation Language
(D) Detailed Data Language
Question 7. Which of the following are the properties of entities?
(A) Groups
(B) Switchboards
(C) Table
(D) Attributes
Question 8. ……. data type can store unstructured data.
(A) VARCHAR
(B) RAW
(C) CHAR
(D) NUMERIC
Question 9. An advantage of the database management approach is ___________.
(A) Data is dependent on programs
(B) Data is integrated and can be accessed by multiple programs
(C) Data redundancy increases
(D) None of the above
Question 10. Which one of the following statements is false?
(A) The data dictionary is normally maintained by the database administrator
(B) The data dictionary contains the name and description of each data element.
(C) The data dictionary is a tool used exclusively by the database administrator
(D) Data elements in the database can be modified by changing the data dictionary.
Question 11. DROP is a ______________ statement in SQL.
(A) DDL
(B) DCL
(C) Embedded SQL
(D) Query
Question 12. Which of the following ensures the atomicity of the transaction?
(A) Application Programmer
(B) Concurrency Control Components of DBMS
(C) Translation management components of DBMS
(D) Recovery Management Components
Question 13. Advantages of File Oriented System is ___________.
(A) Edit
(B) Recovery
(C) Backup
(D) All of the Above
Question 14. Disadvantages of File Oriented System is ____________.
(A) Remove Data Redundancy
(B) Improved Data Sharing
(C) Atomicity problem
(D) Efficient Data access
Question 15. Components of Data Directory is ___________.
(A) Set
(B) Entity
(C) Records
(D) Filed
Question 16. A logical Schema is __________.
(A) Is the Entire Database
(B) Is the standard way to organizing the data in accessible parts
(C) Describe how data actually store in disk
(D) Both (A) and (C)
Question 17. Related Filed in a database are grouped to form a ____________.
(A) Data Record
(B) Menu
(C) Data file
(D) Set
Question 18. collection of related data ____________.
(A) Metadata
(B) Valuable information
(C) Database
(D) Information
Question 19. DBMS help to achieve ____________.
(A) Data independence
(B) Centralized control of data
(C) Neither (A) or (B)
(D) Both (A) And (B)
Question 20. A data Dictionary is a special file that contains:
(A) The name of all filed in all files
(B) The data types of all the filed in all files
(C) The width of all the filed in all files
(D) All of the above
Question 21. ………. keyword is used to find the number of values in a column.
(A) SUM
(B) COUNT
(C) ADD
(D) TOTAL
Question 22. ………. command can be used to modify a column in a table.
(A) Alter
(B) Update
(C) Set
(D) Create
Question 23. To change column value in a table the ……… command can be used.
(A) Create
(B) Alter
(C) Update
(D) Insert
Question 24. To pass on granted privileges to other user the …… clause is used.
(A) Create option
(B) Update option
(C) Select option
(D) Grant option
Question 25. SELECT * FROM employee WHERE dept_name=”Comp Sci”; n the SQL given above there is an error. Identify the error.
(A) “Comp Sci”
(B) From
(C) Dept_name
(D) Employee