View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCEroles and no individual system privileges. The SL_REP user executes this command to create a table:SQL> CREATE TABLE orders(oid number(6), odate date, ccode number(4), oamt number(10,2))TABLESPACE purchase_space;
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes the effect ofthe command()
A.The command executes successfully and creates the table in the USERS tablespace.
B.The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C.The command produces an error because the user does not have the privilege to create the table.
D.The command produces an error because the user does not have quota in the PURCHASE_SPACEtablespace.
您可能感兴趣的试卷
你可能感兴趣的试题
A.Multiplex all database files.
B.Configure the Flash Recovery Area.
C.Configure the database instance for ARCHIVELOG mode.
D.Configure the FAST_START_MTTR_TARGET initialization parameter
A.You can add SQL test cases to the incident package.
B.You can add or remove the trace files to the package.
C.You cannot create an incremental incident package when the physical files are purged from the ADR.
D.You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.
You want to check the details of few errors that users have reported. You search for the alert log file andexecute few commands to find the location of the alert log file. View the Exhibit and check the commandsexecuted.
What is the location of the alert_orcl.log file()
A.ORACLE_HOME/dbs
B.ORACLE_HOME/rdbms
C./u01/app/oracle/admin/orcl/adump
D./u01/app/oracle/flash_recovery_area
E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.
Which is the most effectivemethod to access this data in your database()
A.Use the database link.
B.Use the SQL*Loader utility.
C.Use the Oracle Data Pump utility.
D.Create an external table and leave the data in the flat file
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation()
A.The online redo log files and archived redo log files are required to accomplish the recovery.
B.The uncommitted transaction will be committed at the next startup of the database instance.
C.The uncommitted transaction is rolled back automatically at the next opening of the database.
D.The DBA has to perform the recovery on the database to recover the uncommitted transaction
Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2. The SKD user creates a table.
3. The SKD user grants the CREATE TABLE system privilege to the HR user.
4. The HR user creates a table.
5. The DBA revokes the CREATE TABLE system privilege from SKD.
Which statement is true after step 5 isperformed()
A.The table created by SKD is not accessible and SKD cannot create new tables.
B.The tables created by SKD and HR remain, but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
A.The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D.The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1
View the Exhibit and identify the component marked with a question mark.()
A.Checkpoint (CKPT)
B.Process Monitor (PMON)
C.Archiver Processes (ARCn)
D.Recoverer Process (RECO)
E.Memory Manager process (MMAN)
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0
Which two will be the implications of these values in your database()
A.The SGA advisor will be disabled.
B.The MTTR advisor will be disabled.
C.Automatic checkpoint tuning will be disabled.
D.Checkpoint information will not be written to the alert log file.
View the Exhibit to observe the roles assigned to the SL_REP user.
Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user()
A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes
最新试题
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant(DBCA). You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this()
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command()
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is responsible for issuing alerts when the threshold is crossed()
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
In a new installation of Oracle Database 11g, you perform these activities:1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed()