單項選擇題

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered
SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；
Table created.
Further， you executed the following command to drop the table：
SQL> DROP TABLE emp；Table dropped.
What happens in this scenario？（）

A.The table is moved to the SYSAUX tablespace.
B.The table is moved to the SYSTEM tablespace.
C.The table is removed from the database permanently.
D.The table is renamed and remains in the TBSFD tablespace.

你可能感興趣的試題

多項選擇題

Which two statements about Recovery Manager （RMAN） backups are true？（）

A.Online redo log files can be backed up.
B.Archived redo log files are backed up.
C.Only used data blocks can be backed up as backup sets.
D.Only consistent database backups can be performed.
E.RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.

單項選擇題

The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？（）

A.set the SESSIONS to 1 in the parameter file
B.grant SINGLE SESSION privilege to all of the users
C.set the SESSIONS_PER_USER to 1 in the users’ profile
D.grant RESTRICTED SESSION privilege to all of the database users
E.create a role with SINGLE SESSION privilege and assign the role to the users

你可能感興趣的試題

Which two statements about Recovery Manager （RMAN） backups are true？ （）

Which two statements about Recovery Manager （RMAN） backups are true？（）