It would result in an error because the template cannot be used along with the disk group.
It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.
It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.
第1题:
You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers in the ABC.com domain have Windows Server 2012 R2 installed. You have logged on to a server, named ABC-SR07, and would like to obtain the IP configurations of a server, named ABC-SR13.Which of the following actions should you take?()
第2题:
Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3(user_temp)/user_files/user_tbsp’ SIZE 200M; What would be the result of this command?()
第3题:
You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?()
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
第4题:
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()
第5题:
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?()
第6题:
You work as an administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 R2 on a new ABC.com server,you are instructed to add a graphical user interface (GUI) to the server. You want to achieve this goal from the command prompt. Which of the following actions should you take?()
第7题:
You have created a locally managed tablespace by issuing the following command: CREATE TABLESPACE data1 DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE UNLIMITED; For the DATA1 tablespace, you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated?()
第8题:
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()
第9题:
You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()
第10题:
You work as an administrator at ENSUREPASS.com. The ENSUREPASS.com network consists of a single domain named ENSUREPASS.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 on a new ENSUREPASS.com server, you are instructed to add a graphical user interface (GUI) to the server.You want to achieve this goal from the command prompt. Which of the following actions should you take?()