91. Consider a table OLD with few rows. The statement
CREATE TABLE new AS SELECT * FROM OLD
WHERE 1=2
(a) copies all the rows from OLD to NEW
(b) creates a dummy NEW table
(c) creates an empty NEW table with column definitions same as OLD
(d) creates a table NEW that acts as a synonym for OLD ANS-(c)
92. Oracle 8i runs on
(a) Windows NT
(b) UNIX
(c) Solaris
(d) (a) and (b)
(e) (a), (b) and (c) ANS-(e)
93. The owner of all data dictionary tables in Oracle is
(a) SYSTEM
(b) SYS
(c) INTERNAL
(d) Users ANS-(b)
94. The standard port number at which the Oracle server listens for client requests is
(a) 3128
(b) 8080
(c) 7071
(d) none of these Ans-(d)
95. The address of the Oracle name server is contained in
(a) listener.ora
(b) tnsnames.ora
(c) init.ora
(d) sqlnet.ora ANS-(d)
96. Which of the following is not a RDBMS
(a) MS Access
(b) Oracle 8i
(c) MS SQL Server
(d) Informix ANS-(a)
97. The character used for concatenating strings in Oracle is
(a) &&
(b) +
(c) |
(d) None of these ANS-(d)
98. The datafiles in Oracle, in which the user tables and other objects are stored, resides at
(a) Client side
(b) Server side
(c) Both (a) and (b)
(d) Depends on the configuration ANS-(b)
99. The number of users that can be handled by Oracle 8i server is approximately
(a) 5000
(b) 10000
(c) 1000
(d) 100000 ANS-(b)
100. A precompiler converts
(a) PL/SQL code into executable machine code
(b) Embedded SQL statements into native library calls
(c) A program written in a 3GL into a PL/SQL code
(d) A PL/SQL code into a 3GL code ANS-(b)
101. In a query with a GROUP BY clause, the columns in the SELECT clause
(a) must be aggregate functions only
(b) must also appear in the GROUP BY clause
(c) must also appear in the GROUP BY and HAVING clauses
(d) Both (a) and (b)
(e) Can be selected arbitrarily ANS-(d)
102. OCI stands for
(a) Open Call Interface
(b) Oracle Call Interface
(c) Oracle Communication Interface
(d) Oracle Connection Interface ANS-(b)
103. The name of the only column in the DUAL table is
(a) X
(b) C
(c) DUMMY
(d) None of these ANS-(c)
104. TNS in the file tnsnames.ora stands for
(a) Transparent Network Substrate
(b) Transport Network Substrate
(c) Transparent Network System
(d) Transparent Network Server ANS-(a)
105. Comments in a PL/SQL code are inserted using
(a) –
(b) /* */
(c) Both (a) and (b)
(d) # ANS-(c)
106. The CHAR and NCHAR data types
(a) have no difference
(b) belong to two different character sets
(c) have different storage requirements
(d) have different storage requirements and retrieval time ANS-(b)
107. Consider a table TAB with a single row
NAME
CHARRIS
Then, the query
SELECT SUBSTR(Name,-3) FROM TAB gives
(a) RIS
(b) CHA
(c) ARRIS
(d) ARR ANS-(a)
108. The wild card character % used in strings means
(a) any number of characters
(b) one or more characters
(c) at least one character
(d) at least one alphabet ANS-(a)
|