Computer Science Engineering MCQ
131- Which clause creates a data set, containing several sets of records grouping together based on a condition?
(A) GROUP BY
(B) ORDER BY
(C) HAVING
(D) DISTINCT
132- Which of the following operators is used to match any substring?
(A) _
(B) \
(C) %
(D) ^
133- The ________ clause corresponds to the projection operation of the relational algebra.
(A) WHERE
(B) SELECT
(C) FROM
(D) DISTINCT
134- In Oracle, a database consists of information stored in files and is accessed using
(A) INSTANCE
(B) TABLE
(C) OPERATION
(D) DATA MODEL
135- Which statement is used to confer authorization?
(A) PRIVILEGE
(B) UPDATE
(C) GRANT
(D) SELECT
136- A referential integrity constraint can be specified with the help of _____.
(A) PRIMARY KEY
(B) FOREIGN KEY
(C) COMPOSITE KEY
(D) None of the above
137- Which of the following is a set of one or more attributes that taken collectively, allow us to identify a tuple in the relation uniquely?
(A) SUPERKEY
(B) SUBKEY
(C) PRIMARY KEY
(D) FOREIGN KEY
138- The passing of authorization from one user to another can be represented with
(A) GRAPH
(B) USER GRAPH
(C) AUTHORIZATION GRAPH
(D) DATABASE ADMINISTRATOR
139- The overall design of database is called the database _____.
(A) STRUCTURE
(B) BLOCK
(C) TABLE
(D) SCHEMA
140- _____ is an access strategy, used to sort & search records in the table.
(A) LOCKING
(B) INSERTING
(C) SERIALIZING
(D) INDEXING
ANSWERS:
131-(A), 132-(C), 133-(B), 134-(A), 135-(C), 136-(B), 137-(A), 138-(C), 139-(D), 140-(D)