Install_and_Admin_01

Question 1

The FOR UPDATE clause of the SELECT statement lets you lock the rows selected, so that no other user can update the rows. This clause [can/cannot] be used with queries using the DISTINCT operator.

Answer 1

Cannot

Question 2

The column QUANTITY is defined as NUMBER (*, 2). When you try to store 4569.22, what value will actually be stored?

Answer 2

4569.22

Question 3

How do you define a variable inside a script file if you need to pass the value along with the filename when you execute the script?

Answer 3

&1

Question 4

True or False: When you describe a table using the DESCRIBE command in SQL*Plus, the base table names, column names, and NOT NULL columns are displayed, but invisible columns are not displayed.

Answer 4

True. (SET COLINVISIBLE ON is required to display the invisible columns in DESCRIBE.)

Question 5

Which operator is the most appropriate to use in a single-row subquery?

Answer 5

The = operator

Question 6

True or False: You can replace the table name in the SELECT, INSERT, UPDATE, MERGE and DELETE statements with a subquery.

Answer 6

True

Question 7

Among the special characters *, #, $, and &, which ones can you use to begin a table name?

Answer 7

None. A table name must begin with an alphabetic character.

Question 8

What is the syntax for easy connect?

Answer 8

[//]Host[:Port]/ name>]

Question 9

True or False: When a foreign key constraint is created on Table B, referencing Table A, an index on Table B is automatically created by Oracle, with the columns in the foreign key definition.

Answer 9

False. An index is created only for primary and unique keys if such an index already does not exist.

Question 10

True or False: When adding new columns to a table with rows, you cannot define a NOT NULL constraint.

Answer 10

False

Question 11

What is the maximum number of columns that a table can have?

Answer 11

1,000

Question 12

The architecture makes Oracle Database 12c a true cloud database.

Answer 12

Multitenant

Question 13

True or False: The ALTER TABLE EMP RENAME SAL TO SALARY statement is used to rename the column SAL in the EMP table to SALARY.

Answer 13

True

Question 14

True or False: To be able to store more than 4,000 bytes in VARCHAR2, the DBA needs to set a parameter in database.

Answer 14

True. The MAX STRING SIZE parameter must be EXTENDED.

Question 15

Which datatype stores the actual data outside of the Oracle database?

Answer 15

BFILE datatype