Examine the command that is used to create a table:
SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users;
Which two statements are true about the effect of the above command()
A.A CHECK constraint is created on the OID column.
B.A NOT NULL constraint is created on the OID column.
C.The ORDERS table is the only object created in the USERS tablespace.
D.The ORDERS table and a unique index are created in the USERS tablespace.
E.The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
您可能感兴趣的试卷
你可能感兴趣的试题
A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control file.
D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands
A.Indexes and views can be created on temporary tables.
B.Both the data and the structure of temporary tables can be exported.
C.Temporary tables are always created in a user’s temporary tablespace.
D.The data inserted into a temporary table in a session is available to other sessions.
E.Data manipulation language (DML) locks are never acquired on the data of temporary tables
You want to configure and schedule offline database backups to run automatically.
Which tool or utility wouldyou use to achieve this()
A.The XML script
B.The PL/SQL script
C.The DBMS_SCHEDULER package
D.Enterprise Manager to schedule the backup
A.Running a query on a table returns "ORA-600: Internal Error."
B.Inserting a value in a table returns "ORA-01722: invalid number."
C.Creating a table returns "ORA-00955: name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
E.Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted()
A.The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
B.The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
C.The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command()
A.The tablespace would require recovery to go back online.
B.A checkpoint is taken on all data files that are associated with the SALES tablespace.
C.The sessions that subsequently try to access the objects in the SALES tablespace receive an error
D.The new status of the SALES tablespace is recorded in the control file when the database instance isclosed
Examine the following statement that is used to modify the primary key constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements aretrue regarding the above command()
A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint, but existing data is not checked.
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
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()
A.The retention period to support flashback
B.The expected length of the longest-running query
C.The number of undo tablespaces in the database
D.The size of the Flash Recovery Area for the database instance
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session ofSCOTT in this scenario()
A.The session is terminated after receiving the error and JIM can continue with his transaction.
B.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C.The session is rolled back after receiving the error and JIM can continue with his transaction.
D.SCOTT has to reexecute the last command in the transaction after he commits the transaction.
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgrNUMBER, v_loc NUMBER)BEGIN
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END;
The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would yousuggest to the PL/SQL developers to achieve this()
A.Create the procedure with definer’s right.
B.Create the procedure with invoker’s right.
C.Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D.Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users
最新试题
Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements aretrue regarding the above command()
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 are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
Which statements are true regarding the Oracle Data Pump export and import operations()
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()
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output()
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()
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()