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.
您可能感兴趣的试卷
你可能感兴趣的试题
You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?()
A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
A.Upgrade the hardware/memory to accommodate the data.
B.Load the data into your database by using the PARALLEL clause.
C.Give analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.
D.Use an external table so you can have the metadata available in your database, but leave the data in the operating system files.
A.host naming method
B.local naming method
C.external naming method
D.directory naming method
While planning to manage more than one database in your system, you perform the following activities:
1. Organize different categories of files into independent subdirectories.
2. Use consistent naming convention for database files.
3. Separate administrative information pertaining to each database.
Which option corresponds to the type of activities performed by you?()
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
A.Views can be created as read only.
B.Views are data segments like tables.
C.Views can be created on the basis of more than one table.
D.Data manipulation language (DML) operations cannot be performed on views.
A.control file
B.password file
C.listener controller file
D.control file and password file
A.A role can be granted to itself.
B.Roles are owned by the SYS user.
C.Roles can be granted to other roles.
D.A role cannot be assigned external authentication.
E.A role can contain both system and object privileges.
A.Perform point-in-time recovery to 2: 00 p.m.
B.Use Flashback Table feature to revert the changes.
C.Restore the entire database from the recent backup and open it.
D.Issue the rollback statement with system change number (SCN).
A.You can perform open database backups.
B.You can perform closed database backups.
C.You cannot perform schema-level logical backups.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
A.implementing value-based auditing by using triggers
B.implementing fine-grained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS
最新试题
Which statement is true about the loss of systemcritical data files in ARCHIVELOG mode?()
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
While setting up the database for your production environment, you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace, TBS1, if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective?()
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()