A
B
C
D
第1题:
A.A
B.B
C.C
D.D
第2题:
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?()
A.A
B.B
C.C
D.D
E.E
第3题:
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement: SQL> DROP TABLE SCOTT.EMP PURGE; After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()
第4题:
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
第5题:
Examine the statement: SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully?()
第6题:
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_marks; What is the result of the SELECT statement?()
第7题:
A
B
C
D
E
第8题:
The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected, but these users must re-execute their queries.
The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected, and their queries execute successfully.
第9题:
This command would result in an error because the disk group is not empty.
The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.
The command would result in the disk group being marked as INVALID because it cannot be dropped.
The command would result in the contents being moved to the parent disk group and dropping of the disk group.
The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
第10题:
The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
The statement returns an error at the SELECT clause.
The statement returns an error at the WHERE clause.
The statement returns an error at the ORDER BY clause.
第11题:
The database does not record flashback logs for MY_TABLESPACE
The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
第12题:
DROP TABLESPACE temp1;
DROP TABLESPACE temp1 INCLUDING CONTENTS;
DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS;
第13题:
Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager"FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)AND e.salary > 4000;What is its output?()
A.A
B.B
C.C
D.D
E.E
第14题:
Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement: SQL>ALTER TABLSPACE temp OFFLINE NORMAL; What is the result of this statement?()
第15题:
Your Oracle Database 10g is online when you execute the following statement: SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF; What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
第16题:
In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective: DROP DISKGROUP dgroup1 EXCLUDING CONTENTS; What would be the result of this command?()
第17题:
Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database, and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files (OMF). Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database, its corresponding operating system file is also deleted?()
第18题:
Oracle Managed Files are used for this instance.
The USER_DATA tablespace is managed using FET$/UET$ tables.
The COMPATIBLE initialization parameter must be 9.0.0 or higher.
Space within segments in the USER_DATA tablespace is managed with freelists.
第19题:
The control file will be multiplexed.
The control file will be recreated.
The script containing the CREATE CONTROLFILE statement will be created.
The binary backup of the control file will be created.
第20题:
This command would result in an error because the disk group is not empty.
The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
The command would result in the contents being moved to the parent disk group and dropping of the disk group.
The command would result in the disk group being marked as INVALID because it cannot be dropped.
The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.
第21题:
Exhibit A
Exhibit B
The query returns no rows
The query fails because the outer query is retrieving more than one column
The query fails because both the inner and outer queries are retrieving data from the same table.
第22题:
the datafiles associated with the SYSTEM tablespace
the datafiles associated to the DATA1 tablespace
the datafiles associated to the SYSTEM and DATA1 tablespaces
all the datafiles in the database
第23题:
A
B
C
D