Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders? this query is:

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

This query is: INSERT ALL INTO mytab (c1,c2) VALUES ('ram',12) INTO mytab (c1,c2) VALUES ('mani',15)

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query :-) ?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

where would you find automatic_ipc parameter ?

listener.ora
sqlnet.ora server file
sqlnet.ora client file
tnsnames.ora server file

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following statements creates an Oracle account, but lets the operating system authenticate logons?

create user ops$admin identified by os;
create user ops$admin identified externally;
create user ops$admin nopassword;
create user ops$admin authenticated by os;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following types of statements can use a temporary tablespace?

An index creation
SQL statements with a GROUP BY clause
A hash join operation
All of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following statements gives user desmond the ability to alter table gl.accounts?

grant alter on gl.accounts to desmond;
grant alter to desmond on gl.accounts;
grant alter table to desmond;
allow desmond to alter table gl.accounts;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following statements gives user desmond the ability to alter table gl.accounts as well as give this ability to other accounts?

grant alter any table with grant option to desmond;
grant alter on gl.accounts to desmond with admin option;
grant alter any table to desmond with grant option;
grant alter any table to desmond with admin option;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

The following SQL statement will allow user regina to perform which operations on sequence oe.orders_seq? GRANT ALL ON oe.orders_seq TO regina;

Select the next value from oe.orders_seq.
Alter sequence oe.orders_seq to change the next value.
Change the number of sequence numbers that will be cached in memory.
Both A and C.
All of the above.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

User system granted SELECT on sh.products to user A using WITH GRANT OPTION. A then granted SELECT on sh.products to user B. A has left the company, and his account is dropped. What happens to B’s privileges on sh.products?

B loses his SELECT privilege on sh.products.
B retains his SELECT privilege on sh.products.
B loses his SELECT privilege if A was dropped with the CASCADE REVOKE option.
B retains his SELECT privilege if A was dropped with the NOCASCADE REVOKE option

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases