It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
It generates an error when creating the table because the wallet is closed.
It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
第1题:
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;()
第2题:
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()
第3题:
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? ()
第4题:
You opened the encryption wallet and then issued the following command: SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M ENCRYPTION USING ’3DES168’ DEFAULT STORAGE(ENCRYPT); Then you closed the wallet. Later, you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome?()
第5题:
You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?()
第6题:
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?()
第7题:
The table is moved to the SYSAUX tablespace.
The table is moved to the SYSTEM tablespace.
The table is removed from the database permanently.
The table is renamed and remains in the TBSFD tablespace.
第8题:
the CREATE TABLE .. command
sorting of the SYSTEM tablespace’s data
sorting of data required by recursive SQL statements
the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
sorting of data if the users have not been allocated temporary tablespace explicitly
sorting of data if the users have been allocated temporary tablespace explicitly
第9题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第10题:
It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
It generates an error when creating the table because the wallet is closed.
It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
第11题:
the DBNEWID utility
the ANALYZE command
the RMAN LIST command
the RMAN REPORT command
the RMAN CROSSCHECK command
the RMAN BLOCKRECOVER command
第12题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第13题:
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective?()
第14题:
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()
第15题:
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?()
第16题:
While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第17题:
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?()
第18题:
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday, you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command: SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS; SQL> CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m; After that, you issued the following command to recreate the index: CREATE UNIQUE INDEX sales_index_pk ON sales (order_id) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE ( INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ) NOLOGGING PARALLEL( degree 4) Which two clauses are responsible for reducing the time for the recreation of the index?()
第19题:
SQL scripts
Recovery Manager (RMAN) script
Data Pump
SQL*Loader
Flashback database
第20题:
Rebuild the index.
Coalesce the index.
Drop and re-create the index in the new tablespace.
Relocate the index using the ALTER INDEX...MOVE statement.
第21题:
The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.
第22题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第23题:
It creates the table and encrypts the data in it.
It generates an error because the wallet is closed.
It creates the table but does not encrypt the data in it.
It generates an error because the NO SALT option cannot be used with the ENCRYPT option.