Prepared By : Uday Shah - HOD(IT)
Contact No : 7600044051
---------------------------------------------------------------------------------
1. '> ALL'
means –
same as the IN operator
2. The main purpose of creating a view is for
–
data definition
3. The 'WITH CHECK OPTION' clause of the view
is used to-
restrict access rights
4. Which two statements are true for the ORDER
BY clause?
The default is ascending order
5. Which of the following are true for
creating synonyms?
There are many columns in a table
6. The Top-N Analysis requires-
GROUP BY clause, an inline view
7. What is true about updating a view?
When a view is updated the group
functions are automatically updated
8.
If group functions are used on
columns containing NULL values then-
The NULL values are converted to
appropriate data types
9. Which privileges can be grant on a view?
ALTER, SELECT, INDEX
10. If a user has a CREATE VIEW privilege, it
means he/she can-
create a view in any schema
11. The ROWID is a-
A binary data of 8 megabytes or hexadecimal string
12. The ROWNUM is a-
An octal number
13. Which statement
does not end a transaction-
GRANT
14. Which two statements end a transaction –
DROP
15. Identify the
correct command to create a new user-
CREATE USER newuser IDENTIFIED BY
newuser00
16. An index is most
useful when.
The indexed column does not contain a
wide range of values
17. An Index is automatically
created on.
the first column
18. An index uses
the.
rownum
19. When
'WITH GRANT OPTION' is used in the GRANT command.
It allows the grantee to grant object
privileges to other users
20. The main purpose
of creating a ROLE is.
To have a table that can be accessed
by all
21. _____________ is
an Organized collection of Data.
a) DBMS
22. The Relational
Model of database was introduced by
Dr. E.F.Codd
23. In Database, a
row is also known as
Tuple
24. In entity
relationship model, what are the types of relationship?
One – to – One , One – to – many , Many
– to One
25. Relational
Concept was introduced in the year of
1977
26. Which is one of
the Admin account in Oracle.
System
27. The Last
Buffered command can be executed using
RUN and /
28. Which is the SQL declaration category.
DDL , DCL ,
DML
29. Viewing
data from the user’s created table, which command can be used.
Select Command
30. Converts
a character value to a member using the format provided.
To_Number()
31. ______ clause
can restrict groups.
Having
32. In Oracle Date
Data type can store.
Month ,
Hour , Minute
33. You can share
your own object locally with the help of
Grant
34. In Outer left
and right join, _______ Operator can be userd.
+ ( Plus)
35. Which one is the
TCL Statement.
Commit , Savepoint
36. Which is the set operator in Oracle.
Union ,
Union All , Minus , Intersect
37. View is a.
Logical
Table
38. A
________ is based on a single table and does not contain function or grouped
data.
Simple View
39. Which parameter of the sequence object can not be
altered.
Start with
40. Lock Types are
DML Locks ,
DDL Locks , Latches
41. The Full form of
PL/SQL block is.
Procedural
Language
42. The
Data type that is not supported by oracle table but PL/SQL is.
Boolean
43. To know the
status of Cursor, we use
Cursor
Attributes
44. To avoid
any data type mismatches in PL/SQL we
can use.
%type
45. Cursor attribute
are prefixed with the cursor name
in
Explicit Cursor
46. The default
parameter mode is
IN Mode
47. Exception can be
raised using
Raise_Application_Error
48. _____
is name PL/SQL module that can perform one or more task and does not contain
any return value.
Function
49. Instead of
Trigger is based on VIEW instead of a database table.
True
50. Which type of
file is part of the Oracle Database.
Control
File
51. Transaction per
roll back segment is derived from.
Processes
52. _____ file
reside on the client.
TNSNAMES.ORA
53. ____
Media recovery is used to recover from a lost or damaged current data file or
control file.
Datafile
54. When Database is
running 24 * 7 basis , the backup should be
Online
Backup
55. In
Relational Database Terminology, Columns is called _________
Attribute
56. E
– R Diagram is one of the Model that was
Developed By ________ in 1976.
P.P.Chen
57. When the tables
are formed with primary keys, the DBMS is in
1NF
58. Date
must be inserted according to oracle format only that is, __________
DD/MON/YY
59. Which
operator return TRUE result if one of the two condition is TRUE?
AND
60. SQL is Case –
Insensitive.
TRUE
61. RDBMS Tools are
DBMS
, RDBMS , MS SQL Server
62. Online Backup is
also called.
Hot
63. NET8 Interface
is for
Both Client
and Server
64. The Session Information
is stored in
PGA
65. Which has same
Size?
Data Block
66. Cursor is a
_____ workarea.
Temporary
67. The
__________ can be used to initialize a constant
or a variable to a value.
:=
68. ____________ is
a pre – test loop
While
69. _____ Provide auto
increment and auto declaration of Variable.
For Loop
70. When
the variable is not initialized in PL/SQL block, it contains __________ value.
a) NULL
71. Two Copies of
the same table is created in memory if the join is.
Self Join
72. _______
Marks and saves the current point in the processing of a transaction.
Savepoint
73. _________ return
current data and time.
SYSDATE ()
74. The Symbol of
concatenation operation in oracle is
| |
75. Which category
can be used for Table Structure only.
DDL
76. To compare
Single Character with Like Operator
_
(Dash)
77. Which satisfy
all 12 rules for ideal RDBMS.
None
78. The Query is
Process By
Server
79. Lock Types are
..
All
80. The ____ Loop does not need an EXIT statement to terminate.
While
81. A primary key is
always
Unique and not null
82. A foreign key
can refer to a
Only primary key of another table
83. The constraint,
which can be defined only at column level, is
Not null
84. A foreign key
can be specified with the table name only when
Both columns have same datatype and
column width
85. Which of the
following is not a character data type?
BLOB
86. Entity Integrity
rule refers to the
Primary key
87. Referential
Integrity rule refers to the
Foreign key
88. A single check
constraint can refer to more than one column at
Table level only
89. 'On delete
cascade' is used to
Delete parent records and
corresponding child records
90.
A unique index is created for
which two constrains from the following
Primary key , Unique Constraint
91. When you create a table, which of the
following holds true?
It is created in the DBA schema
92.
When the DBA creates a user using
the command – CREATE USER username IDENTIFIED BY password, which privileges dose have at this
point?
No privilege
93. Maximum size of naming a table?
Maximum size is 30 characters
94.
Which of the following
modifications are not allowed once the table is created but is not empty?
Decreasing the size of column
95. The RENAME
command can't be used to change the name of
A column
96. The NUMBER data type can't be used for
Hexadecimal
97. The DATE data type stores
MON/DD/YY
