databases Online Quiz - 230
Description: databases Online Quiz - 230 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
The default password of root user is
What will be the output of the query select * from table1 order by rand()
Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;
The mysql contains a user root?
The default password of root user is
What will be the output of the query select * from table1 order by rand()
Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
Which of the following can be a valid column name?
Which command will delete all data from a table and will not write to the rollback segment?
Which character function can be used to return a specified portion of a character string?
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
Which character is used to continue a statement in SQL*Plus?
What is the best way for a deadlock to be resolved?
When an executable SQL statement executes, a transaction begins. Which of the following events can NOT cause a transaction to end?
Which dictionary view or views should be monitored to determine how long users are waiting for dispatchers?
Which of the following options would be queried to get the descriptions of all tablespaces?
A single database session failure is classified as what type of error?