1. The connective tests for set membership, where the set is a collection of values produced by a select clause. The connective tests for the absence of set membership.
Correct : C. in, not in
2. The phrase “greater than at least one” is represented in SQL by
Correct : D. > some
3. SQL applies predicates in the clause after groups have been formed, so aggregate functions may be used.
Correct : B. with
4. The keyword is used to access attributes of preceding tables or subqueries in the from clause.
Correct : B. lateral
5. Which of the following creates a temporary relation for the query on which it is defined?
Correct : A. with
6. Subqueries cannot:
Correct : C. join tables
7. Which of the following is not an aggregate function?
Correct : C. with
8. The EXISTS keyword will be true if:
Correct : A. any row in the subquery meets the condition only
9. How can you find rows that do not match some specified condition?
Correct : B. double use of not exists
10. Which one of the following deletes all the entries but keeps the structure of the relation.
Correct : D. delete from instructor;
11. The problem of ordering the update in multiple updates is avoided using
Correct : C. case
12. The condition allows a general predicate over the relations being joined.
Correct : A. on
13. Which of the join operations do not preserve non matched tuples?
Correct : C. inner join
14. What type of join is needed when you wish to include rows that do not have matching values?
Correct : C. outer join
15. How many tables may be included with a join?
Correct : D. all of the mentioned
16. Which are the join types in join condition:
Correct : D. all of the mentioned
17. How many join types in join condition:
Correct : D. 5
18. The operation which is not considered a basic operation of relational algebra is
Correct : A. join
19. In SQL the statement select * from R, S is equivalent to
Correct : B. select * from r cross join s
20. Which of the following creates a virtual relation for storing the query?
Correct : B. view
21. Materialised views make sure that
Correct : B. view definition is kept up-to-date
22. Updating the value of the view
Correct : A. will affect the relation from which it is defined
23. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
Correct : C. with check
24. A consists of a sequence of query and/or update statements.
Correct : A. transaction
25. In order to undo the work of transaction after last commit which one should be used?
Correct : C. rollback
26. In case of any shut down during transaction before commit which of the following statement is done automatically?
Correct : C. rollback
27. In order to maintain the consistency during transactions, database provides
Correct : B. atomic
28. A transaction completes its execution is said to be
Correct : A. committed
29. Which of the following is used to get back all the transactions back after rollback?
Correct : C. flashback
30. will undo all statements up to commit?
Correct : C. rollback
31. Which of the following is not an integrity constraint?
Correct : B. positive
32. Domain constraints, functional dependency and referential integrity are special forms of
Correct : C. assertion
33. Which of the following is the right syntax for the assertion?
Correct : A. create assertion ‘assertion-name’ check ‘predicate’;
34. Data integrity constraints are used to:
Correct : C. improve the quality of data entered for a specific property (i.e., table column)
35. Dates must be specified in the format
Correct : B. yyyy/mm/dd
36. A on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
Correct : A. index
37. Which of the following is used to store movie and image files?
Correct : B. blob
38. The user defined data type can be created using
Correct : D. create type
39. Values of one type can be converted to another domain using which of the following?
Correct : A. cast
40. Which of the following closely resembles Create view?
Correct : B. create table . . . as
41. In contemporary databases, the top level of the hierarchy consists of each of which can contain
Correct : A. catalogs, schemas
42. The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
Correct : D. all of the mentioned
43. Which of the following is used to provide privilege to only a particular attribute?
Correct : B. grant update(budget) on department to raj
44. Which of the following is true regarding views?
Correct : C. if a user creates a view on which no authorization can be granted, the system will allow the view creation request
45. If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the clause to the appropriate grant command.
Correct : D. with grant option
46. Which of the following is used to avoid cascading of authorizations from the user?
Correct : B. revoke select on department from amit, satoshi restrict;
47. The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation
Correct : A. the privilege must be granted only by roles
48. Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?
Correct : B. dynamic sql
49. Which of the following header must be included in java program to establish database connectivity using JDBC ?
Correct : A. import java.sql.*;
50. Which of the following invokes functions in sql?
Correct : C. callable statements
51. Which of the following function is used to find the column count of the particular resultset?
Correct : A. getmetadata()
52. Which of the following is used as the embedded SQL in COBOL?
Correct : B. exec sql <embedded sql statement > end-exec
53. Which of the following is used to distinguish the variables in SQL from the host language variables?
Correct : B. –
54. Which of the following is used to access large objects from a database ?
Correct : D. all of the mentioned
55. A is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
Correct : B. triggers
56. Triggers are supported in
Correct : C. views
57. What are the after triggers?
Correct : B. these triggers run after an insert, update or delete on a table
58. The variables in the triggers are declared using
Correct : B. @
59. The default extension for an Oracle SQL*Plus file is:
Correct : D. .sql
60. Which of the following is NOT an Oracle- supported trigger?
Correct : B. during
61. What are the different in triggers?
Correct : C. insert, update, delete
62. Triggers enabled or disabled
Correct : A. can be
63. Which prefixes are available to Oracle triggers?
Correct : C. both :new and : old
64. Any recursive view must be defined as the union of two subqueries: a query that is nonrecursive and a query.
Correct : A. base, recursive
65. Ranking of queries is done by which of the following?
Correct : B. order by
66. In rank() function if one value is shared by two tuples then
Correct : B. the rank order continues by leaving one rank in the middle
67. The function that does not create gaps in the ordering.
Correct : D. dense_rank()
68. If there are n tuples in the partition and the rank of the tuple is r, then its is defined as (r −1)/(n−1).
Correct : C. percent_rank
69. Inorder to simplify the null value confusion in the rank function we can specify
Correct : D. either nulls last or first
70. The command such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
Correct : B. create temporary table
71. OLAP stands for
Correct : A. online analytical processing
72. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
Correct : A. slicing
73. The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a
Correct : A. rollup
74. In SQL the cross-tabs are created using
Correct : A. slice
75. What do data warehouses support?
Correct : A. olap
76. Which one of the following is the right syntax for DECODE?
Correct : D. decode (expression, search, result [, search, result]… [, default])
77. Relational Algebra is a query language that takes two relations as input and produces another relation as an output of the query.
Correct : C. procedural
78. Which of the following is a fundamental operation in relational algebra?
Correct : D. none of the mentioned
79. Which of the following is used to denote the selection operation in relational algebra?
Correct : B. sigma (greek)
80. For select operation the appear in the subscript and the argument appears in the paranthesis after the sigma.
Correct : A. predicates, relation
81. The operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
Correct : B. set-difference
82. Which is a unary operation:
Correct : D. generalized selection
83. Which is a join condition contains an equality operator:
Correct : A. equijoins
84. Which of the following is not outer join?
Correct : D. all of the mentioned
85. The assignment operator is denoted by
Correct : B. <-
86. Which of the following symbol is used in the place of except?
Correct : C. ¬
87. Which of the following is the comparison operator in tuple relational calculus
Correct : B. =
88. In domain relaional calculus “there exist”
Correct : D. Э x (p1(x))
89. A set of possible data values is called
Correct : D. domain
90. An is a set of entities of the same type that share the same properties, or attributes.
Correct : A. entity set
91. Entity is a
Correct : C. thing in real world
92. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
Correct : B. composite attribute
93. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
Correct : D. derived
94. Not applicable condition can be represented in relation entry as
Correct : C. null
95. Which of the following can be a multivalued attribute?
Correct : A. phone_number
96. Which of the following is a single valued attribute
Correct : A. register_number
97. In a relation between the entities the type and condition of the relation should be specified. That is called as attribute.
Correct : A. desciptive
98. express the number of entities to which another entity can be associated via a relationship set.
Correct : A. mapping cardinality
99. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as
Correct : B. one-to-one
100. An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.