Question 1

The default password of root user is

technology databases

My$ql
Linuxab$
""
None of the above

Answer

Correct Option: C

Question 2

What will be the output of the query select * from table1 order by rand()

technology databases

Error
All columns ordered randomly
rows picked in a random way
None of the above

Answer

Correct Option: C

Question 3

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE [email protected]_price OR [email protected]_price;

technology databases

True
False

Answer

Correct Option: B

Question 4

What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;

technology databases

Would skip the first 7, and then get you the next ten highest.
not a valid mysql query
Would skip the first 10, and then get you the next 7 highest.
None of the above

Answer

Correct Option: A

Question 5

The mysql contains a user root?

technology databases

True
False

Answer

Correct Option: B

Question 6

The default password of root user is

technology databases

My$ql
Linuxab$
""
None of the above

Answer

Correct Option: C

Question 7

What will be the output of the query select * from table1 order by rand()

technology databases

Error
All columns ordered randomly
rows picked in a random way
None of the above

Answer

Correct Option: C

Question 8

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE [email protected]_price OR [email protected]_price;

technology databases

True
False

Answer

Correct Option: B

Question 9

What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;

technology databases

Would skip the first 7, and then get you the next ten highest.
not a valid mysql query
Would skip the first 10, and then get you the next 7 highest.
None of the above

Answer

Correct Option: A

Question 10

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

technology databases

Primary key access
Access via unique index
Table access by ROWID
Full table scan

Answer

Correct Option: C

Question 11

Which of the following can be a valid column name?

technology databases

Column
1966_Invoices
Catch_#22
#Invoices

Answer

Correct Option: C

Question 12

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

DROP
DELETE
CASCADE
TRUNCATE

Answer

Correct Option: D

Question 13

Which character function can be used to return a specified portion of a character string?

technology databases

INSTR
SUBSTRING
SUBSTR
POS

Answer

Correct Option: C

Question 14

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

technology databases

System tablespace
Users tablespace
Default tablespace for the user
Oracle will give an error

Answer

Correct Option: C

Question 15

Which character is used to continue a statement in SQL*Plus?

technology databases

*
/
-
@

Answer

Correct Option: C

Question 16

What is the best way for a deadlock to be resolved?

technology databases

All statements are removed and have to be resubmitted
The Oracle server rolls back the statement that detected the deadlock
The administrator has to kill the session
Deadlocks can not be resolved

Answer

Correct Option: B

Question 17

When an executable SQL statement executes, a transaction begins. Which of the following events can NOT cause a transaction to end?

technology databases

The user disconnects from Oracle
A COMMIT or a ROLLBACK statement is used in conjunction with a SAVEPOINT clause
A user process is terminated abnormally
A DDL statement such as DROP, GRANT, RENAME

Answer

Correct Option: B

Question 18

Which dictionary view or views should be monitored to determine how long users are waiting for dispatchers?

technology databases

V$SESSTAT
V$QUEUE
V$SHARED_SERVER
V$VIEW

Answer

Correct Option: B

Question 19

Which of the following options would be queried to get the descriptions of all tablespaces?

technology databases

USER_TABLESPACES
V$TABLESPACE
DBA_TABLESPACE_GROUPS
DBA_TABLESPACES

Answer

Correct Option: D

Question 20

A single database session failure is classified as what type of error?

technology databases

Statement failure
User process failure
Network failure
Instance failure

Answer

Correct Option: B

Description: databases Online Quiz - 230
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 230

Find more quizzes from top tags