网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（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 OIDcolumn in the SYSTEM tablespace.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.” 相关考题
考题
Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()
A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
考题
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged
考题
Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）A.B.C.D.
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result?（）A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B. It fails and reports an error because the CONTAINER=ALL clause is not used.C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$ sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command?（）A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.B. It fails because no SQL *Loader data file location is specified.C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.D. It fails because no SQL *Loader control file location is specified.
考题
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.
考题
Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
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 operations can be performed on an external table（）A、Create a view on the table.B、Create an index on the table.C、Create a synonym on the table.D、Add a virtual column to the table.E、Update the table using the UPDATE statement.F、Delete rows in the table using the DELETE command
考题
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true 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 checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题Examine the CREATE DISKGROUP command used to create a disk group： SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2； In which situation would you use this method of disk group creation？（）A
When two-way disk mirroring is required for the allocation unitsB
When three-way disk mirroring is required for the allocation unitsC
When using hardware mirroring or RAIDD
When disk mirroring is required for the Automatic Storage Management （ASM） disks
考题
单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）A
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.B
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C
One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.D
One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E
One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
考题
多选题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（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL *Loader.DNew data conforms to the constraint， but existing data is not checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A
The ALTER TABLE command modifies the column successfully.B
The DDL operation gets higher priority and transaction for user a is rolled back.C
The ALTER TABLE command waits indefinitely until user a ends the transaction.D
The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
考题
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT orROLLBACK command， user B executes the following command on the TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A
The ALTER TABLE command modifies the column successfully.B
The DDL operation gets higher priority and transaction for user A is rolled back.C
The ALTER TABLE command waits indefinitely until user A ends the transaction.D
The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
考题
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A
All database operations performed by the impdp command are logged.B
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D
None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
考题
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）A
Automatic statistics collection is stopped for the CUSTOMERS table.B
Statistics for the CUSTOMERS table are locked and cannot be overwritten.C
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D
Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
考题
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A
The commands execute successfully.B
Command 6 produces an error because of circular role grant.C
Command 5 produces an error because a role cannot be granted to another role.D
Command 3 produces an error because the MGRROLE role already contains system privileges.E
The table created by HR remains and HR still has the CREATE TABLE system privilege.F
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
多选题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（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
考题
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $ sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
考题
多选题Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A
The tablespace TBS1 is full.B
The user is not the owner of the SYSTEM tablespace.C
The user does not have quota on the TBS1 tablespace.D
The user does not have sufficient system privileges to create table in the TBS1 tablespace.E
The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A
Automatic statistics collection is stopped for the CUSTOMERS table.B
Statistics for the CUSTOMERS table are locked and cannot be overwritten.C
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D
Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
考题
单选题Examine the CREATE DISKGROUP command used to create a disk group: SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?（）A
When two-way disk mirroring is required for the allocation unitsB
When three-way disk mirroring is required for the allocation unitsC
When using hardware mirroring or RAIDD
When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
单选题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.
考题
单选题Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A
The shrink operation touches every block in the BOOKING tableB
The high-water mark （HWM） for the BOOKING table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
考题
单选题In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create table FROM C # # A_ADMIN;What is the result?（）A
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B
It fails and reports an error because the CONTAINER=ALL clause is not used.C
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D
It fails and reports an error because the CONTAINER=CURRENT clause is not used.E
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
热门标签
最新试卷
