Tag: databases

Question 1

What data dictionary view will display information about the columns in the database that have constraints?

technology databases

USER_CONSTRAINTS
USER_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_TABLE

Answer

Correct Option: B

Question 2

What PL/SQL control structure is known as an IF-THEN statement?

technology databases

Conditional
Sequential
Iterative
Loop

Answer

Correct Option: A

Question 3

Which section of a PL/SQL block commences with the BEGIN keyword?

technology databases

Exception
Executable
Declarative
Anonymous

Answer

Correct Option: B

Question 4

Which constraint can be defined only at the column level?

technology databases

UNIQUE
NOT NULL
CHECK
PRIMARY KEY

Answer

Correct Option: C

Question 5

Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

technology databases

17000.00
17000*****
**17000.00
An error statement

Answer

Correct Option: D

Question 6

SELECT TO_CHAR(1000000, '$99,999.00') SALARY FROM dual What Is the Output?

technology databases

NNNNNNN
########
1000000
1000000.00

Answer

Correct Option: B

Question 7

There are also multiple-column subqueries: Queries that return more than one column from the inner SELECT statement.(T/F)

technology databases

True
False

Answer

Correct Option: A

Question 8

What is the output in RR format for following dates Date Specified :27-Oct-1995

technology databases

2017
1917
1900
2000

Answer

Correct Option: B

Question 9

The outer and inner queries can get data from different tables?

technology databases

True
False

Answer

Correct Option: A

Question 10

Which statement describes the ROWID data type?

technology databases

binary data up to 4 gigabytes
character data up to 4 gigabytes
a hexadecimal string representing the unique address of a row in its table
raw binary data of variable length up to 2 gigabytes

Answer

Correct Option: C

Tag: databases

Questions Related to databases