Tag: databases

Questions Related to databases

This is the name of the database object containing information about all comments on table....
technology databases

  1. USER_COMMENTS

  2. USER_ALL_COMMENTS

  3. USER_TAB_ALL

  4. USER_TAB_COMMENTS

Show answer
Correct Option: D

CREATE TABLE Persons( P_Id int NOT NULL AUTO_INCREMENT=100, LastName varchar(255) NOT NULL);
technology databases

  1. When trying to enter NULL value for P_Id then 100 will be placed there.

  2. P_Id value starts from 1 and then it is auto incremented by value 1 upto 100.

  3. Generates error as there is no constraint like "AUTO_GENERATE".

  4. P_Id value starts from 100 and then it is auto incremented by value 1.

Show answer
Correct Option: D

what is true about function now();

technology databases

  1. Returns current system date and time.

  2. Returns only current time

  3. Returns only current date.

  4. There is no function like now();

Show answer
Correct Option: A

select round(1601.916718 -3) from dual.
technology databases

  1. 1601.916

  2. 2000

  3. 1598

  4. 1598.916

Show answer
Correct Option: B

REPLACE('GEORGE' 'GE' NULL);
technology databases

  1. NULLORNULL

  2. GEGE

  3. OR

  4. 2

Show answer
Correct Option: C

What are the Sql Cursor Attributes in Pl/sql?
technology databases

  1. SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

  2. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

  3. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

  4. All of the above

Show answer
Correct Option: C

How Many minimum lines of code required to compile the Pl/Sql block successfully?
technology databases

  1. 2

  2. 3

  3. 4

  4. None of the above

Show answer
Correct Option: B

Which statement removes the function?
technology databases

  1. DROP gen_email_name;

  2. REMOVE gen_email_name;

  3. DELETE gen_email_name;

  4. DROP FUNCTION gen_eamil_name;

Show answer
Correct Option: D

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ?

technology databases

  1. Yes

  2. No

  3. 1 & 2

  4. None of the above

Show answer
Correct Option: B

What is true about stored procedures?

technology databases

  1. A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters

  2. A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.

  3. A stored procedure must have at least one executable statement in the procedure body.

  4. A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.

Show answer
Correct Option: C