51. If every determinant is a candidate key, then the relation is in
a. First Normal form
b. Second Normal form
c. Third Normal form
d. BCNF
52. A relation is in BCNF and has no multi valued dependencies
a. Second
b. Third
c. Fourth
d. Domain key Normal Form
53. If A determines B but B does not determine A, then
a. One to one relationship
b. Many to one relationship
c. Normalized relationship
d. Many to many relationship
54. Which of the following should not be in a relational table?
a. Entity
b. Attribute
c. Repeating group
d. Relationship
55. These objects can be represented by a single relation in the database:
a. Simple objects
b. Composite objects
c. Compound objects
d. Hybrid objects
56. Atleast two relations are required to represent this type of object:
a. Simple objects
b. Composite objects
c. Compound objects
d. Hybrid objects
57. These objects require atleast three relations for their representation
a. Association objects
b. Composite objects
c. Compound objects
d. Hybrid objects
58. SQL is
a. Procedural language
b. Non-procedural language
c. Not a data sub language
d. None
59. To remove duplicate rows this qualifier must be specified
a. ONLY
b. UNIQUE
c. DISTINCT
d. SINGLE
60. Which SQL keyword is used to delete a table’s structure?
a. Delete
b. Drop
c. Update
d. Alter
61. In SQL asterisk (*) means:
a. All columns of table are selected
b. All records meeting the criteria are returned
c. All records with partial criteria met are returned
d. None
62. In an SQL query, which built in function is used to compute the number of rows in a table?
a. AVG b. MAX c. MIN d. COUNT
63. In an SQL query, which keyword is used with built in function to group rows that have the same value in a specified column together?
a. GROUP BY
b. ORDER BY
c. SELECT
d. SORT BY
64. In an SQL query, which SQL keyword is used to implement a subquery?
a. GROUP BY
b. HAVING
c. ORDER BY
d. SELECT
65. In an SQL query, which keyword is used to specify the names of tables to be joined?
a. FROM b. HAVING c. JOIN d. SELECT
66. In SQL, which keyword is used to specify the condition for a join operation?
a. FROM
b. HAVING
c. WHERE
d. SELECT
67. Which SQL keyword is used to change a column value?
a. CHANGE b. INSERT c. SELECT d. SET
68. Which of the following are five built in functions of SQL:
a. COUNT, SUM, AVG, MAX, MIN
b. SUM, AVG, MIN, MAX, MULT
c. SUM, AVG, MULT, DIV, MIN
d. SUM, AVG, MIN, MAX, NAME
69. Which of the following is not an SQL statement used on a single table?
a. SELECT with WHERE
b. SELECT with GROUP BY
c. SELECT with GROUP BY and HAVING
d. SELECTION
70. Which of the following is not an SQL command category:
a. DDL b. DML c. DGL d. DCL
71. Which is NOT an advantage of using a view?
a. Simplify query commands
b. Provide data security
c. Enhanced programming productivity
d. Decrease system overhead
72. Which keyword is NOT used in most data retrieval statements?
a. Select b. As c. From d. Where
73. Which can only interact with relational database and table like data structure?
a. OLE DB b. ODBC c. ASP d. All
74. The ODBC standard defines a means of doing which of the following?
a. Start transactions
b. Rollback transactions
c. Create a connection
d. All
75. The intermediary between application and DBMS drivers in ODBC architecture is
a. Driver manager
b. OLE DB interface
c. ODBC driver
d. Data source
76. ODBC interface are abstractions of _________
a. OLE objects
b. Native DBMS access methods
c. Driver manager
d. DBMS data sources
77. A driver ________ is a set of functions that the application can call to receive services
a. OLE object
b. DBMS data source
c. API
d. System
78. One _____ key can be created for each table
a. Primary
b. Foreign
c. Unique
d. None of them
79. With SQL, how do you select all the columns from a table names “Persons”?
a. SELECT [all] FROM Persons
b. SELECT All Persons
c. SELECT * Persons
d. SELECT * FROM Persons
80. A table is in 3NF if it is in 2NF and it contains no partial dependencies
a. True
b. False
c. Statement is not clear
81. DDL stands for
a. Database Designing Language
b. Data Dictionary Language
c. Data Definition Language
d. Database Directory Language
82. Relational model creator _____
a. Relational Thomas
b. E.F.Codd
c. Relational CODD
d. R.F Thomas
83. _________ is an operation that select specified attributes from a relation
a. Selection
b. Projection
c. Product
d. Difference
84. Which of these is not an anomaly?a. Insertion
b. Deletion
c. Modification
d. Creation
85. Foreign key may contain null values
a. True
b. False
c. Statement is not clear
86. You can use arithmetic operators in any clause of a SQL statement except the _____ clause
a. SELECT
b. FROM
c. WHERE
d. None of them
87. You can place the sub-query in the SQL-ORDER BY Clause:
a. True
b. False
c. Statement is not clear
88. If Student and Course participate in a relationship then it is
a. Unary Relationship
b. Binary Relationship
c. Ternary Relationship
d. Coupled Relationship
89. A relation is in _______ normal form, if all non-key attributes are dependent on all of the key
a. Second
b. Third
c. Boyce Codd
d. Fourth
90. What is a tuple?
a. Another name for the key linking different tables in a database
b. An attribute attached to a record
c. Another name for a table in an RDBMS
d. A row or a record in a database table
91. Which of the following is a problem of file management system
a. Difficult to update
b. Data redundancy
c. Program dependence
d. All of above
92. Which of the following fields in a student file can be used as a primary key?
a. Class
b. CNIC
c. Marks Obtained
d. Subject
93. A data dictionary is a special file that contains:
a. The names of all fields in all files
b. The data types of all fields in all files
c. The widths of all fields in all files
d. All of them
94. What is the language used by most of the DBMS for helping their users to access data
a. High level language
b. SQL
c. HTML
d. Java
95. What type of join is used when you wish to include rows that do not have matching values?
a. Equi-join
b. Natural-join
c. Outer-join
d. All of them
96. Which group function ignores null values?
a. Avg() b. Count(*) c. Sum() d. a & c both
97. The _________ of two relations is the concatenation of every tuple of one relation with every
tuple of a second relation
a. Selection
b. Projection
c. Product
d. Difference
98. Which of the following constraints enforces entity integrity?
a. PRIMARY KEY
b. FOREIGN KEY
c. CHECK
d. NOT NULL
99. Which of the following is not true about relational tables?
a. Column values are of the same kind.
b. Each row is unique.
c. Each column must have a unique name.
d. The sequence of rows is significant
100. In a conceptual model for a university, what type of relationship exists between Grade
and Student entities?
a. 1:1 b. 1:M c. M:M d. Ternary