The table created by SKD isnot accessibleand SKD cannot create new tables.
The tables created by SKD and HR remain, but both cannot create new tables.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
第1题:
Which of the following step libraries is included in the license for IPCC Express Standard? ()
第2题:
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
第3题:
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()
第4题:
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()
第5题:
Cleanup obsolete data
Clear the WebSphere Commerce cache
Enable WebSphere Commerce Accelerator
Reindex the database tables
Run Performance Monitor to monitor SQL statements
第6题:
2,1,4,3,5,6
1,4,3,2,6,5
1,4,2,6,3,5
3,2,1,4,5,6
第7题:
The database instance is running with manual PGA management.
The database instance is running with manual shared memory management.
The database instance has the MEMORY_TARGET value set to a nonzero value.
All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed
第8题:
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
第9题:
4, 1, 3, 2, 5
4, 3, 1, 2, 5
2, 4, 3, 5, 1
4, 2, 5, 3, 1
第10题:
The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
All the user-defined tablespaces must be in read-only mode on the source database.
The export dump file must be created before starting the import on the target database.
The source and target database must be running on the same platform with the same endianness.
The path of data files on the target database must be the same as that on the source database.
The impdp operation must be performed by the same user that performed the expdp operation.
第11题:
The table created by SKD is not accessible and SKD cannot create new tables.
The tables created by SKD and HR remain, but both cannot create new tables.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
第12题:
4, 1, 3, 2, 5
4, 3, 1, 2, 5
2, 4, 3, 5, 1
4, 2, 5, 3, 1
第13题:
Examine the following steps performed on a database instance: 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed()
第14题:
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true()
第15题:
You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第16题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?()
第17题:
Start the instance and open the database, instance recovery automatically recovers control files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第18题:
2,1,4,3,5,6
1,4,3,2,6,5
1,4,2,6,3,5
3,2,1,4,5,6
第19题:
7,1,5,2,3,6,4
1,2,3,7,5,6,4
7,1,4,5,2,3,6
1,7,5,4,2,3,6
第20题:
Shut down the database.
Set the appropriate parameters in init.ora file.
Start the database in NOMOUNT state.
Issue the ALTER DATABASE ARCHIVELOG command.
Open the database.
Take a full closed backup.
第21题:
It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
A single listener can service only one database instance and multiple remote client connections.
Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
第22题:
1,2,3,4
3,2,4,1
4,2,1,3
4,3,2,1
第23题:
The backup will not be performed at all.
three times
four times
six times