1. Which
algebra is widely used in computer science:
a. Arithmetic
algebra
b.
Relational
algebra
c. Both
d. None
2. _____algebra
has similar power of expression as relational calculus and first order logic:
a. Arithmetic
algebra
b.
Relational
algebra
c. Both
d. None
3. In
relation algebra a new term was defined by codd as __________:
a. Relation
b.
Relation
completeness
c. Relation
operation
d. Relation
selection
4. How
many primitive operators of relation algebra as proposed by codd:
a. 2
b. 3
c. 4
d.
6
5. Which
are the primitive operators of relation algebra as proposed by codd:
a. Selection
b. Projection
c. Cartesian
product
d. Set
union
e. Set
difference
f.
Rename
g.
All of these
h. None
of these
6. Which
is a unary operation:
a. Selection
operation
b. Primitive
operation
c. Projection
operation
d.
Generalized
selection
7. Relational
calculus can be divided into how many calculi:
a. 2
b. 3
c. 4
d. 5
8. Which
is relation calculus:
a. Tuple
relation calculus
b. Domain
relational calculus
c.
Both
d. None
9. Which
calculus is based on specifying a number of tuple variables:
a.
Tuple
relation calculus
b. Domain
relational calculus
c. Both
d. None
10. SQL is used
for interacting with___:
a. DBMS
b.
RDBMS
c. DDL
d. SDL
11. SQL is a
______languages:
a. Database
languages
b.
Declarative
languages
c. Both
d. None
12. ISO stands
for:
a. Input
standards organization
b. Interrupt
standard organization
c.
International
standards organization
d. None
of these
13. Which is a
collection of a defined group of database object like tables, indexes, tablespace:
a.
Database
b. Record
c. Memory
d. All
of these
14. A_____ is a
single non-decomposable data element in a table:
a. View
b.
Column
c. Tablespace
d. None
of these
15. SQL outputs
a single table known as the ______:
a. View
b. Column
c. Tablespace
d.
Result set
16. How many forms
of SQL:
a.
2
b. 4
c. 6
d. None
of these
17. Which are
form of SQL:
a. Interactive
b. Embedded
c.
Both
d. None
18. In SQL which
operators on a data base to produce output for user demand:
a.
Interactive
b. Embedded
c. Both
d. None
19. In SQL
which command can be put inside a program written in some other languages like
C,C++:
a. Interactive
b.
Embedded
c. Both
d. None
20. Data is
passed to a program environment through______:
a. DBMS
b.
SQL
c. DDL
d. SDL
21. DQL stands
for:
a. Data
query line
b.
Data query
languages
c. Data
query land
d. Direct
query languages
22. TCL stands
for:
a.
Transaction
control languages
b. Transaction
command languages
c. Transaction
connect languages
d. None
of these
23. Which is
that part of SQL that allows a database user to create and restructure data
base objects:
a. DBMS
b. SQL
c.
DDL
d. SDL
24. ______commands
in SQL allow controlling access to data within database:
a. Database
b. Data
c.
Data control
d. All
of these
25. How many interfaces
provided by oracle:
a. 1
b. 2
c. 3
d.
4
26. In which
are interface provided by oracle:
a. SQL
*PLUS
b. SQL*PLUS
command line interface
c. SQL
Plus Worksheet(introduced in ORACLE8i)
d. SQL
*PLUS(introduced in ORACLE9i)
e.
All of these
f.
None of these
27. SQL has how many main commands for DDL:
a. 1
b. 2
c.
3
d. 4
28. Which are
main commands for DDL in SQL:
a. CREATE
b. ALTER
c. DROP
d.
All of these
29. How many
data types in oracle:
a.
2
b. 3
c. 4
d. 5
30. In which
are the data types in oracle:
a. ANSI
standard data types
b. Oracle
defined data types
c.
Both
d. None
31. A_____ is a
query that retrieves rows from more than one table or view:
a. Start
b. End
c.
Join
d. All
of these
32. A condition is referred to as _____:
a. Join
in SQL
b.
Join
condition
c. Both
d. None
33. Which
oracle is the join condition is specified using the WHERE clause:
a. Oracle
9i
b. Oracle
8i
c.
Pre-oracle
9i
d. Pre-oracle
8i
34. Oracle-9i
is supported by the__________ syntax:
a. ANSI
SQL-96
b. ANSI
SQL-97
c. ANSI
SQL-98
d. ANSI
SQL-99
35. How many
join types in join condition:
a. 2
b. 3
c. 4
d.
5
36. Which are
the join types in join condition:
a. Cross
join
b. Natural
join
c. Join
with USING clause
d. Outer
join
e. Join
with ON clause
f.
All of these
37. How many
tables in a join query have no join condition:
a.
2
b. 3
c. 4
d. None
of these
38. Which
product is returned in a join query have
no join condition:
a. Equijoins
b.
Cartesian
c. Both
d. None
39. Which is a
join condition contains an equality operator:
a.
Equijoins
b. Cartesian
c. Both
d. None
40. Which
command defines its columns, integrity
constraint in create table:
a.
Create
command
b. Drop
table command
c. Alter
table command
d. All
of these
41. It refers to
set of one or more columns that designates the ______ key in a referential
integrity constraint:
a. Select
key
b.
Foreign key
c. Write
key
d. None
of these
42. Which
constraint that requires that the column contain a value when it is initially
inserted into the table:
a. IS
NULL
b.
NOT NULL
c. UNIQUE
d. None
43. Which
constraint that identifies a column or combination of columns as a unique key:
a. IS
NULL
b. NOT
NULL
c.
UNIQUE
d. None
44. Which
command is use for removing a table and all its data from the database:
a. Create
command
b.
Drop table command
c. Alter
table command
d. All
of these
45. Which
command that allows the removal of all rows from a table but flushes a table
more efficiently since no rollback information is retained:
a.
TRUNCATE
command
b. Create
command
c. Drop
table command
d. Alter
table command
46. Which join
refers to join records from the write table that have no matching key in the
left table are include in the result set:
a. Left
outer join
b.
Right outer
join
c. Full
outer join
d. Half
outer join
47. How many set
operations supports the oracle SQL:
a. 2
b. 3
c.
4
d. 5
48. Which are
the set operations supports the oracle SQL:
a. UNION
b. UNION
ALL
c. INTERSECT
d. MINUS
e.
All of these
49. ______
operator merges the result sets of two component queries:
a. UNION
b.
UNION ALL
c. INTERSECT
d. MINUS
50. How many
component queries are combined using the set operators:
a. 1
b.
2
c. 3
d. 4
51. In
precedence of set operators the expression is evaluated from______:
a. Left
to Left
b. Right
to Right
c.
Left to
Right
d. Right
to Left
52. View in SQL
a view may be defined as a :
a. Stored
query
b. Virtual
table
c.
Both
d. None
53. Which views
is using in several advantages:
a. Simplicity
b. Security
c. User
reports
d. Data
integrity
e.
All of these
54. How many
types of views in SQL:
a. 1
b. 2
c.
3
d. 4
55. Which are
the types of views in SQL:
a. Inline
view
b. Database
view
c. Materialized
view
d.
All of these
56. Which
operation are allowed in a join view:
a. UPDATE
b. INSERT
c. DELETE
d.
All of these
57. The materialized
view was introduced by:
a. Oracle
6
b. Oracle
7
c.
Oracle 8
d. Oracle
9
58. We can delete from join view provided there
is__________ key preserved table in the join:
a.
One and Only
One
b. One
and Two
c. Two
and One
d. None
of these
59. Which view
that contains more than one table in the top-level FROM clause of the SELECT
statement:
a. Join
view
b. Datable
join view
c.
Updatable
join view
d. All
of these
60. Which
option is used to create a view as a constrained view and prohibit specific
insert and update operations with the view:
a. DATABASE
b.
WITH CHECK
OPTION
c. WITH
WRITE OPTION
d. WITH
OPTION
61. Which
command is used to add the views to the database:
a. DATABASE
VIEW
b.
CREATE VIEW
c. CREATE
OPTION
d. None
of these
62. Which
option is used with the WHERE clause:
a. DATABASE
b.
WITH CHECK
OPTION
c. WITH
WRITE OPTION
d. WITH
OPTION
63. Which
option may be used to create the inline view as a constrained view:
a. DATABASE
b.
WITH CHECK
OPTION
c. WITH
WRITE OPTION
d. WITH
OPTION
64. In which
year ORACLE, an SQL product was released:
a. 1976
b. 1977
c.
1978
d. 1979
65. The prototype
for SQL was originally developed by:
a. INTEL
b. APPLE
c.
IBM
d. All
of these
66. In which
year relational algebra became prominent after the relational model of database
was published:
a. 1969
b.
1970
c. 1971
d. 1972
67. Relational
algebra became prominent after the relational model of database was published
by:
a.
Codds
b. F.F.
codd
c. E.E.
codd
d. None
of these
68. Which is an
ANSI standard and has many different versions:
a. IBM
b.
SQL
c. RDBMS
d. ORACLE
69. Which is
used for interfacing with RDBMS:
a. IBM
b.
SQL
c. ANSI
d. ORACLE
70. Which is
the basis for SQL and also for all other contemporary database system like MS
SQL Server, IBM DB2, Oracle, My SQL and MICROSOFT Access:
a. DDL
b. SDL
c.
RDBMS
d. None
of these
Thanks It's Very Helpfull...:)
ReplyDelete