-
You issued the following command:
https://assets.asklib.com/images/image2/2018080210302149486.jpg
An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? （）
A . It stores only the temporary table but not its indexes.
B . It stores both the temporary table as well as its indexes.
C . It must be a nondefault temporary tablespace for the database.
D . It can be a default or nondefault temporary tablespace for the database.
E . It must be the default temporary tablespace of the user who issues the command.
-
You are working on the Certkiller database. What is the default name of the alert log file in this database？（）
A . alert_ Certkiller .log
B . alertlog_ Certkiller .log
C . alert_log_ Certkiller .log
D . Certkiller _alert_log.log
E . log_alert_： Certkiller .log
F . trace_alert_ Certkiller .log
-
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
A . By multiplexing the control files
B . By multiplexing the redo log files
C . By decreasing the size of redo log files
D . By configuring mean time to recover （MTTR） to a lower value
E . By setting the UNDO_RETENTION parameter to a higher value
-
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
A . Flashback logs are not archived.
B . Flashback logs are maintained in redo log files.
C . Flashback logs are maintained in the Flash Recovery Area.
D . Flashback logs are used to maintain Flashback Database related errors.
E . Flashback logs need to be cleared manually after you disable Flashback Database.
-
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
A . loss of a tempfile
B . loss of a system data file
C . loss of one of the control files
D . loss of one of the tablespaces
E . loss of a member from each redo log group
F . loss of the only member of an unarchived redo log grou
-
You have a portable computer that runs Windows 7. The computer is configured to keep an offline versionof files located in a network share. You need to identify whether you are working on an offline version of a file. What should you do?（）
A . From Sync Center， click View sync partnerships.
B . From Action Center， click View archived messages.
C . From Windows Explorer， select the file and then view the toolbar.
D . From Windows Mobile Device Center， click the Connection settings.
-
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
A . SYSDATE should not be used with TIMESTAMP.
B . The database must have multiplexed redo log files.
C . The database must be in the MOUNT state to execute the command.
D . The database must be opened with the RESETLOGS option after the flashback operation.
E . The entire database needs to be restored from the most recent backup before the flashback operation.
-
You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time？（）
A . By multiplexing the control files
B . By multiplexing the redo log files
C . By decreasing the size of redo log files
D . By configuring mean time to recover （MTTR） to a lower value
E . By setting the UNDO_RETENTION parameter to a higher value
-
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
A . loss of one of the tablespaces
B . loss of a system data file
C . loss of one of the control files
D . loss of a tempfile
E . loss of the only member of an unarchived redo log group
F . loss of a member from each redo log grou
-
If you know that the vessel you are about to call on the VHF radio maintains a radio watch on both the working and the calling frequencies，which frequency should you call on? （）
A . Calling frequency
B . Distress frequency
C . Urgency frequency
D . Working frequency
-
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）
A . The Flashback Archive FLA1 is dropped only if it is empty.
B . The tablespace having Flashback Archive is dropped.
C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D . The Flashback Data Archive and historical data are dropped.
-
You work as a technician at TestKing. You are configuring a Cisco router. You want to configure the IP address on an interface.Which command should you use?（）
A . router(config-if)#ip address 142.8.2.1 subnet mask 255.255.252.0
B . router(config-if)#142.8.2.1 0.0.3.255
C . router(config-if)#ip address 142.8.2.1 255.255.252.0
D . router(config-if)#142.8.2.1 subnet mask 255.255.252.0
E . router(config-if)#ip address 142.8.2.1 0.0.3.255
F . router(config-if)#ip address 142.8.2.1 subnet mask /22
-
You are working on an existing Web site. You need to secure the Web site by redirecting all users to the logon page, Login.aspx. After logging on, users must be sent back to the page that they originally requested. Which code segment should you use?（）
A .https://assets.asklib.com/images/image2/2018072714005024244.jpg
B .https://assets.asklib.com/images/image2/201807271401023676.jpg
C .https://assets.asklib.com/images/image2/2018072714010645375.jpg
D .https://assets.asklib.com/images/image2/2018072714011271828.jpg
-
You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
A . The database crashes.
B . The DBA needs to re-create the file.
C . The file gets re-created automatically.
D . The file gets restored automatically from the last backup.
E . The DBA needs to perform a complete database recovery.
F . The DBA needs to perform an incomplete database recovery.
-
You are working on an existing Web site. You need to secure the Web site by redirecting all users to the logon page, Login.aspx. After logging on, users must be sent back to the page that they originally requested. Which code segment should you use? （）
A . In the Web.config file: <authorization> <deny users="?" /></authorization> On each page in the Web site: Protected Sub Page_Load(ByVal sender As Object, _ ByVal e As System.EventArgs) Handles Me.Load FormsAuthentication.Initialize() End Sub
B . On each page in the Web site: Protected Sub Page_Load(ByVal sender As Object, _ ByVal e As System.EventArgs) Handles Me.Load FormsAuthentication RedirectToLoginPage("login.aspx") End Sub
C . On each page in the Web site: Protected Sub Page_Load(ByVal sender As Object, _ ByVal e As System.EventArgs) Handles Me.Load Response.Redirect("login.aspx") End Sub
D . In the Web.config file: <authentication mode="Forms"> <forms name=".ASPXUSERDEMO" loginUrl="login.aspx" protection="All" timeout="60" /></authentication>
-
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
A . You can perform consistent backups only.
B . You can perform a complete database backup without shutting down the database instance.
C . You can back up data files only when all data files have the same SCN recorded in the control file.
D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command
-
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）
A . SYSDATE should not be used with TIMESTAMP.
B . The database must have multiplexed redo log files.
C . The database must be in the MOUNT state to execute the command.
D . The database must be opened with the RESETLOGS option after the flashback operation.
E . The entire database needs to be restored from the most recent backup before the flashback operation.
-
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
A . To recover a dropped table.
B . To recover a dropped schema.
C . To recover data from a truncated table.
D . To view changes made by all the transactions during a given period of time.
E . To view changes made by a single transaction during a given period of time.
-
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
A . You can perform consistent backups only.
B . You can perform a complete database backup without shutting down the database instance.
C . You can back up data files only when all data files have the same SCN recorded in the control file.
D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
-
M:Hi, Jane! How are things with you?W: Oh, I’m now working on a new project.Question: What’s the woman doing now?
-
听力原文：W: Mr. Mars, you are going to take over my job as secretary here from next Monday on. Now let me tell you the office rules first. The working hours are from eight to twelve in the morning and from one to five in the afternoon.
M: Thank you, Miss Kim.
W: The most important thing is that our boss makes a point of keeping everything in order. So you'd better not throw things about. Otherwise, he'll be mad at you.
M: Ok, I will bear that in mind. Thanks a lot for what you have told me.
Who is Miss Kim？
A．She is the new boss.
B．She is the manager.
C．She is a clerk.
D．She is a secretary.
-
You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command？ （）
<img src='https://img2.soutiyun.com/shangxueba/ask/64263001-64266000/64265568/67e67a73b604e73a7d1e2def2ff7dcea.jpg' />
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
-
You are working on an existing Web site. You need to secure the Web site by redirecting all users to the logon page, Login.aspx. After logging on, users must be sent back to the page that they originally requested.Which code segment should you use？（）
A.<img src='https://img2.soutiyun.com/shangxueba/ask/64260001-64263000/64260017/31ddc27d6b5afe8bae451bdd794657cf.jpg' />
B.<img src='https://img2.soutiyun.com/shangxueba/ask/64260001-64263000/64260017/19ad18c2d6af540e3af3cc6cf5e26d31.jpg' />
C.<img src='https://img2.soutiyun.com/shangxueba/ask/64260001-64263000/64260017/c6671967b4ef53d8df6205db1b9bc9dc.jpg' />
D.<img src='https://img2.soutiyun.com/shangxueba/ask/64260001-64263000/64260017/f2dbfcb0e5210e6a8f01932d905b2566.jpg' />
