网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）
A
The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.
B
The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
C
The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
D
The statement results in an error because there are open PDBs.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）A The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.B The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.C The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.D The statement results in an error because there are open PDBs.” 相关考题
考题
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）A. It succeeds because the PDB_ADMIN user has the required privileges.B. It fails because common users are unable to use the SET CONTAINER statement.C. It fails because local users are unable to use the SET CONTAINER statement.D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
考题
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?（）A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.
考题
You run a script that completes successfully using SQL*Plus that performs these actions:1. Creates a multitenant container database (CDB)2. Plugs in three pluggable databases (PDBs)3. Shuts down the CDB instance4. Starts up the CDB instance using STARTUP OPEN READ WRITEWhich two statements are true about the outcome after running the script?（）A. The seed will be in mount state.B. The seed will be opened read-only.C. The seed will be opened read/write.D. The other PDBs will be in mount state.E. The other PDBs will be opened read-only.F. The PDBs will be opened read/write.
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result?（）A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B. It fails and reports an error because the CONTAINER=ALL clause is not used.C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.A multitenant container database (CDB) instant has the following parameter set:THREADED_EXECUTION = FALSEWhich four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）A. You can conned as a common user by using the connect statement.B. You can connect as a local user by using the connect statement.C. You can connect by using easy connect.D. You can connect by using OS authentication.E. You can connect by using a Net Service name.F. You can connect as a local user by using the SET CONTAINER statement.
考题
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
考题
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.The CDB has several pluggable databases (PDBs) open in the read/write mode.There are ongoing transactions in both the CDB and PDBs.What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.D. The statement results in an error because there are open PDBs.
考题
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
考题
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）A、Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.B、The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.C、The command will, create a common user whose description is contained in the root and each pdb.D、The schema for the common user C # # A_ADMIN can be different in each container.E、The command will create a user in the root container only because the container clause is not used
考题
You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
考题
In user-managed backup and recover procedures， how are data files backed up？ （）A、Using SQL commands.B、Using SQL*Plus commands.C、Using operating system commands.D、Using Recover Manager commands.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal？（）A、You should recapture the workload by using the data collector.B、You should enable the XP_MSVER stored procedure on the local server.C、You should enable the XP_MSVER stored procedure on the remote serverD、You should recapture the workload to a trace file by using SQL Profiler.
考题
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 two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can return records that contain the word "root". What should you do?（） A、You should terminate and restart the MSFTESQL service B、You should rebuild the full-text index C、The word "root" should be added to the stop list D、The word "root" should be added to the thesaurus file
考题
Which two are attributes of /SQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
多选题In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）AThe C # # ROLE1 role is created in the root database and all the PDBs.BThe C # # ROLE1 role is created only in the root database because the container clause is not used.CPrivileges are granted to the C##A_ADMIN user only in the root database.DPrivileges are granted to the C##A_ADMIN user in the root database and all PDBs.EThe statement for granting a role to a user fails because the CONTAINER clause is not used.
考题
单选题You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）A
It succeeds because the PDB_ADMIN user has the required privileges.B
It fails because common users are unable to use the SET CONTAINER statement.C
It fails because local users are unable to use the SET CONTAINER statement.D
If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
考题
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
考题
多选题You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）AThe seed will be in mount state.BThe seed will be opened read-only.CThe seed will be opened read/write.DThe other PDBs will be in mount state.EThe other PDBs will be opened read-only.FThe PDBs will be opened read/write.
考题
单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）A
Place the root container in ARHCHIVELOG mode.B
Take the user data tablespace offline.C
Place the root container in the nomount stage.D
Ensure that HR_PDB is open.
考题
多选题An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）AYou can conned as a common user by using the connect statement.BYou can connect as a local user by using the connect statement.CYou can connect by using easy connect.DYou can connect by using OS authentication.EYou can connect by using a Net Service name.FYou can connect as a local user by using the SET CONTAINER statement.
考题
单选题You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A
creating a table in your schema and you exceed your allocated space quota on the tablespaceB
executing a long query that involves a sort operation and the statement runs out of temporary spaceC
loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD
creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
考题
单选题Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）A
Data files that belong to only the root containerB
Data files that belong to the root container and all the pluggable databases (PDBs)C
Data files that belong to only the root container and PDB$SEEDD
Data files that belong to the root container and all the PDBs excluding PDB$SEED
考题
多选题Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）ASchema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.BThe C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.CThe command will, create a common user whose description is contained in the root and each pdb.DThe schema for the common user C # # A_ADMIN can be different in each container.EThe command will create a user in the root container only because the container clause is not used
考题
多选题Which two are characteristics of user-managed backup and recovery operations？（）ARecovery is initiated using SQL*Plus.BDatabase files are backed up using SQL commands.CDatabase files are backed up with Recovery Manager.DDatabase files are restored using Recovery Manager.EDatabase files are backed up using operating system commands.
考题
单选题In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create table FROM C # # A_ADMIN;What is the result?（）A
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B
It fails and reports an error because the CONTAINER=ALL clause is not used.C
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D
It fails and reports an error because the CONTAINER=CURRENT clause is not used.E
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
多选题You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
考题
多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.AUpdatingBViewingCDeletingDInsertingETruncating
考题
单选题You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）A
The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.B
The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.C
The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.D
The statement results in an error because there are open PDBs.
热门标签
最新试卷
