网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
A
the DBNEWID utility
B
the ANALYZE command
C
the RMAN LIST command
D
the RMAN REPORT command
E
the RMAN CROSSCHECK command
F
the RMAN BLOCKRECOVER command
参考答案
参考解析
解析：
暂无解析
更多 “单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）A the DBNEWID utilityB the ANALYZE commandC the RMAN LIST commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the RMAN BLOCKRECOVER command” 相关考题
考题
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? ()
A. An error is generated.B. You will have two identical tables in the HR schema with different names.C. You create a table called employees in the HR schema based on you EMP table.D. You create an alternative name for the employees table in the HR schema in your own schema.
考题
You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhat happens when you execute this DELETE statement? DELETE employees; （）A. You get an error because of a primary key violation.B. The data and structure of the EMPLOYEES table are deleted.C. The data in the EMPLOYEES table is deleted but not the structure.D. You get an error because the statement is not syntactically correct.
考题
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.
考题
Examine these two statements:Which three are true about the MRKT tablespace?()
A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.B. The MRKT tablespace may be dropped if it has no contents.C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.D. No more data files can be added to the tablespace.E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT 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）， 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.
考题
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）A、MERGEB、INSERTC、UPDATED、ADDE、ENTERF、You cannot enter the phone numbers for the existing employee records.
考题
Which two operations can be flashed back using the Flashback technology？（）A、DROP USER SMITH；B、DROP TABLE EMPLOYEES；C、DROP TABLESPACE USERS；D、ALTER TABLE SALES_REP DROP PARTITION P1；E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
考题
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） A、the DBNEWID utilityB、the ANALYZE commandC、the RMAN LIST commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the RMAN BLOCKRECOVER command
考题
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 work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？ （）A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table （IOT）D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.
考题
单选题You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？ （）A
The table is partitionedB
The table name is wrong.C
It is an index-Organized table （IOT）D
The table is stored in locally managedtablespace.E
The table is stored in atablespacewhere segment space is managed manually.
考题
单选题Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）A
An error is generated.B
You will have two identical tables in the HR schema with different names.C
You create a table called employees in the HR schema based on you EMP table.D
You create an alternative name for the employees table in the HR schema in your own schema.
考题
单选题You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）A
You get an error because of a primary key violation.B
The data and structure of the EMPLOYEES table are deleted.C
The data in the EMPLOYEES table is deleted but not the structure.D
You get an error because the statement is not syntactically correct.
考题
单选题While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）A
the CREATE TABLE .. commandB
sorting of the SYSTEM tablespace’s dataC
sorting of data required by recursive SQL statementsD
the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE
sorting of data if the users have not been allocated temporary tablespace explicitlyF
sorting of data if the users have been allocated temporary tablespace explicitly
考题
单选题You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）A
You get an error because of a primary key violation.B
The data and structure of the EMPLOYEES table are deleted.C
The data in the EMPLOYEES table is deleted but not the structure.D
You get an error because the statement is not syntactically correct.
考题
单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。A
identify the segments that you should shrinkB
modify the storage parameters for the tablespaceC
automatically shrink the segments with unused spaceD
check the alerts generated for the tablespace that is running low on space
考题
单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）A
the DBNEWID utilityB
the ANALYZE commandC
the RMAN LIST commandD
the RMAN REPORT commandE
the RMAN CROSSCHECK commandF
the RMAN BLOCKRECOVER command
考题
单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A
The EMPLOYEES table will be changed to read-only mode during the shrink operation.B
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
考题
单选题The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLEA
Only the EMPLOYEES table.B
Only the EMPLOYEES table and its corresponding primary key index.C
The EMPLOYEES table and partition P1.D
The EMPLOYEES table， IPK_EMP index， and the SALES table.
考题
单选题You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）A
MERGEB
INSERTC
UPDATED
ADDE
ENTERF
You cannot enter the phone numbers for the existing employee records.
考题
单选题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 executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A
The data in the segment will be compacted but the high water mark will not be adjusted B
The EMPLOYEES table will be changed to read-only mode during the shrink operation C
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overD
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation E
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
考题
单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）A
DROP TABLE B
ALTER TABLE C
RESIZE D
COALESCE
考题
单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）A
OPTIMAL B
INITIAL C
PCTINCREASE D
NEXT
考题
多选题Which two operations can be flashed back using the Flashback technology？（）ADROP USER SMITH；BDROP TABLE EMPLOYEES；CDROP TABLESPACE USERS；DALTER TABLE SALES_REP DROP PARTITION P1；EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
热门标签
最新试卷