单选题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 indi

题目
单选题
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？（）
A

 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.

B

 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.

C

 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.

D

 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

相似考题

1.You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()A.SYSTEMB.SYSAUXC.EXAMPLED.UNDOE.TEMPF.USERS

2. 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？（）A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.C、 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.D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

3. You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1  What is the effect of this command if L1 is the only listener configured for your database？（）A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs， so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".

4.You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.

更多“Twenty database users are connected to your database. Five o”相关问题

  • 第1题：

    You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）

    • A、SYSTEM
    • B、SYSAUX
    • C、EXAMPLE
    • D、UNDO
    • E、TEMP
    • F、USERS

    正确答案:A,B,E

  • 第2题：

    Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：  LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance？（）

    • A、The sessions are able to perform only queries.
    • B、The sessions are not affected and continue to function normally.
    • C、The active transactions are rolled back and the sessions get terminated.
    • D、The sessions are not allowed to perform any operations till the listener is started.

    正确答案:B

  • 第3题：

    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

    • A、renaming the control files
    • B、dropping a user in your database
    • C、enabling or disabling redo log archiving
    • D、dropping a tablespace in your database
    • E、re-creating the control files， after you lost all the control files in your database

    正确答案:C

  • 第4题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第5题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
    A

    renaming the control files

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created？（）
    A

     It is a list of remote database links stored in the XML file that are available to the users of the database.

    B

     It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

    C

     It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.

    D

     It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    多选题
    Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）
    A

    BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

    B

    BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

    C

    BACKUP DATABASE while connected to the PDB1 container

    D

    BACKUP DATABASE while connected to the boot container

    E

    BACKUP PLUGGABLE database PDB1 while connected to PDB2


    正确答案： A,D
    解析： 暂无解析

  • 第9题：

    单选题
    The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）
    A

    media

    B

    instance

    C

    statement

    D

    user process


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
    A

    Restore and recover the datafile. 

    B

    Restore and recover the tablespace. 

    C

    Restore and recover the database. 

    D

    Restore and recover the control file. 

    E

    Restore and recover the parameter file.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command.
    A

    a， c， f， g

    B

    b， c， f， h

    C

    a， b， c， f， g

    D

    a， b， c， f， g， h

    E

    b， c， f， e， g


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and performtablespacerecovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

    • A、Create a single storage group. Create one database for all users
    • B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database
    • C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database
    • D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes

    正确答案:C

  • 第14题：

    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

    • A、Restore and recover the datafile. 
    • B、Restore and recover the tablespace. 
    • C、Restore and recover the database. 
    • D、Restore and recover the control file. 
    • E、Restore and recover the parameter file.

    正确答案:A

  • 第15题：

    Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 

    • A、a， c， f， g
    • B、b， c， f， h
    • C、a， b， c， f， g
    • D、a， b， c， f， g， h
    • E、b， c， f， e， g

    正确答案:B

  • 第16题：

    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

    • A、 V$DATABASE
    • B、 V$UNDOSTAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$FLASHBACK_DATABASE_STAT

    正确答案:C

  • 第17题：

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）
    A

    User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；

    B

    User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；

    C

    User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；

    D

    User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；

    E

    User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；


    正确答案： E
    解析： 暂无解析

  • 第19题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance？（）
    A

    The sessions are able to perform only queries.

    B

    The sessions are not affected and continue to function normally.

    C

    The active transactions are rolled back and the sessions get terminated.

    D

    The sessions are not allowed to perform any operations till the listener is started.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）
    A

    Writes buffers to disk 

    B

    Writes current redo log number to datafile headers 

    C

    Writes redo log information to disk 

    D

    Reads information into memory for users


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?（）
    A

    Bob has max_user_connections set to zero, which blocks all his connections

    B

    Joe has exceeded the max_user_connections global limit

    C

    All users are blocked because max_user_connections is accumulated over the host account information

    D

    Kay is already connected elsewhere and attempting to log in again

    E

    Connect_timeout is too small to allow a connection to occur


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）
    A

    Use the Database Resource Manager.

    B

    Set the limits in the profiles used by users.

    C

    Modify the SESSIONS initialization parameter.

    D

    Set the warning threshold for the Current Logons Count metric.


    正确答案： B
    解析： 暂无解析

相关内容