网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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=SAMPLE
A
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.
参考答案
参考解析
解析:
暂无解析
更多 “单选题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 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 data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?()A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
考题
Which statement is correct about the forwarding table?()
A. The forwarding table is stored only on the PFEB. The forwarding table contains all known routesC. The forwarding table is stored on both the RE and PFED. The forwarding table is stored only on the RE
考题
Which type of EIGRP route entry describes a feasible successor?()A、a primary route,stored in the routing tableB、a backup route,stored in the routing tableC、a backup route,stored in the topology tableD、a primary route,stored in the topology 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.
考题
Which statement is true about the forwarding table?()A、The forwarding table is stored in the control plane only.B、The forwarding table is stored in the control plane and in the forwarding plane.C、The forwarding table contains both active and inactive routes.D、The forwarding table can contain only a single next hop per destination.
考题
Which statement is correct about the forwarding table?()A、The forwarding table is stored only on the PFEB、The forwarding table contains all known routesC、The forwarding table is stored on both the RE and PFED、The forwarding table is stored only on the RE
考题
Which statement is true about the forwarding table?()A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination
考题
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.
考题
单选题Which statement is true about the forwarding table?()A
The forwarding table is stored in the control plane onlyB
The forwarding table is stored in the control plane and in the forewarding planeC
The forwarding table contains both active and inactive routesD
The forwarding table can contain only sigle next hop per destination
考题
单选题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.
考题
单选题下列哪一个命令为删除sample数据库的tb_name表()。A
delete from tb_nameB
delete from samplE.tb_nameC
drop table samplE.DBO.tb_nameD
drop table samplE.tb_name
考题
单选题Which statement is true about the forwarding table?()A
The forwarding table is stored in the control plane only.B
The forwarding table is stored in the control plane and in the forwarding plane.C
The forwarding table contains both active and inactive routes.D
The forwarding table can contain only a single next hop per destination.
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
多选题Which two statements are true of the forwarding table?()AThe forwarding table is stored in the control plane only.BThe forwarding table contains both active and inactive routes.CThe forwarding table is stored in the control plane and the forwarding plane.DThe forwarding table uses a longest match lookup for forwarding decisions.
考题
单选题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
考题
多选题Examine these two statements:Which three are true about the MRKT tablespace?()AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.BThe MRKT tablespace may be dropped if it has no contents.CUsers who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.DNo more data files can be added to the tablespace.EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
热门标签
最新试卷