[2026] Oracle Database 11g Essentials - 1Z0-514 무료 시험 문제

문제1

Evaluate the following command: $sqlplus / noblog
In which scenario would the above command execute successfully?

A. Eitherfrom the server or client even if the database instance is not up.

B. Only from the server if the database instance is not up.

C. Either from a client or server only if the database instance is up but the command does not connect the session to the instance.

D. Either from a client or server only if the database instance is up and the command connectsthe session to the instance.

정답: A

문제2

Which two statements are true regarding the Undo Retention Settings? (Choose two.)

A. Undo Retention indicates the time period or which uncommitted transaction data is retained.

B. Undo Retention Indicates the time period for which committed transaction data is retained.

C. Enabling Retention Guarantee ensures that only long-running Queries do not fail.

D. Enabling Retention Guarantee ensures that long running queries and transactions do not fail.

정답: B,D

문제3

Which two statements are true regarding the usage of tools in administering an Oracle database? (Choose two.)

A. Data Pump: transfer of data from one database to another

B. SQL*Loader: load data horn an Oracle database to an external file

C. Database configuration Assistant (DBCA): create new database userin an existing database

D. Database Upgrade Assistant: upgradeonly single-instance databases

E. Oracle Net Manager: configure a new or existing listener

정답: A,E

문제4

You added the Following code in the tnsnames.ora file in the client PC:
Sales=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=tcp) (HOST=salesdatA. (PORT=1521))
(SRVICE_NAME = sales.acme))
Which statement is true regarding the above code with respect to creating a new connect identifier?

A. It gets created for a database, SALESDATA, on the serverSALES in the network domain called.

B. It generates an error because the conned identifier name cannot be apart of the SERVICE_NAME.

C. It generates an error because the server configuration mode dedicated or shareD. is not specified.

D. It gets created for a database, SALE,in the not work domain ACME on the SALESDATA server.

정답: B

문제5

Which three statements are true regarding the Database Configuration Assistant (DBCA. templates? (Choose three)

A. Templates are stored as XML files.

B. A new template can be created using either an existing database or template.

C. Seed templates contain only the logical strut tuna of .in existing database.

D. Seed templates contain both the logical structure and physical files of an existing database.

E. Templates are stored as HTML files.

F. A new template can be created using only an existing database.

정답: A,B,D

문제6

You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
Which three constraints must be explicitly enforced on the table? (Choose three)

A. not null constraint on the DATE_OF_BIRTH column

B. foreign key constraint on the COURSE_ID column

C. unique key constraint on the STUDENT_ID column

D. check constraint on the COURSE_ID column

E. primary key constraint on the STUDENT_ID columns

F. check constraint on the DATE_OF_BIRTH column

정답: B,E,F

문제7

Which three statements are true regarding an Oracle instance? (Choose three)

A. Multiple database instances can run on one computer.

B. One instance is associated with only one database.

C. Only one database instance can run on one computer.

D. A database instance is created based on the information in the SPFILE file.

E. A database instance is created based on the information in the control file.

F. One instance can be associated with multiple databases.

정답: A,B,D

Oracle Database 11g Essentials - 1Z0-514무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트