0

SQL Database

Description: SQL Database
Number of Questions: 15
Created by:
Tags: SQL Database Database Oracle Java/Oracle /C/C++
Attempted 0/15 Correct 0 Score 0

Which of the following languages in SQL is involved in retrieval of data, insertion of new data and deletion or modification of existing data?

  1. DDL

  2. DML

  3. TCL

  4. Schema

  5. Data structure


Correct Option: B
Explanation:

This language in SQL is involved in retrieval of data, insertion of new data and deletion or modification of existing data.

Which of the following exceptions is raised in PL/SQL when a select statement returns zero rows?

  1. TOO_MANY_ROWS

  2. VALUE_ERROR

  3. NO_DATA_FOUND

  4. INVALID_NUMBER

  5. ZERO_DIVIDE


Correct Option: C
Explanation:

This exception is raised in PL/SQL when a select statement returns zero rows.

Which of the following in SQL represents the set of all permissible values for that particular column?

  1. Tuple

  2. Data

  3. Domain

  4. Entity

  5. Files


Correct Option: C
Explanation:

This in SQL represents the set of all permissible values for that particular column.

Which of the following is the first step in starting database in Oracle?

  1. Mounting the database

  2. Opening the database

  3. Instance creation

  4. Shutting down the database

  5. Force


Correct Option: C
Explanation:

This is the first step in starting the database in Oracle.

Which of the following loops does not exist in PL/SQL?

  1. While loop

  2. Loop-Endloop

  3. For loop

  4. Do-while loop

  5. Goto statement.


Correct Option: D
Explanation:

This loop does not exist in PL/SQL. This statement allows one to change the flow of control within a PL/SQL block

Which command is used to remove rows from a table?

  1. Delete

  2. Remove

  3. Truncate

  4. Both (1) and (3)


Correct Option: D

Which of the following is the characteristic of a relational database model?

  1. Tables

  2. Treelike structures

  3. Complex logical relationship

  4. Records


Correct Option: A

Which command is used to remove a table or index from the database in SQL?

  1. Delete Table

  2. Drop table

  3. Erase Table

  4. None of above


Correct Option: B

The command used to select only one copy of each set of duplicable rows is called

  1. Select distinct

  2. Select unique

  3. Select different

  4. None of above


Correct Option: A

Which of the following SQL statements displays all the data that exist in the table at that point of time?

  1. Select all from Table_Name

  2. Select * Table_Name

  3. Select full from Table_Name

  4. Select full Table_Name

  5. Select * from Table_Name


Correct Option: E
Explanation:

Yes, it displays all the data that exist in the table.

How many categories does SQL support to communicate with database?

  1. 5

  2. 4

  3. 3

  4. 6


Correct Option: B

________ is used to query and manipulate existing objects like tables.

  1. Data definition language

  2. Data manipulation language

  3. Transaction control language

  4. Data control language


Correct Option: B

_______ is/are application development tool(s) of Oracle for developing and executing reports.

  1. SQL plus

  2. PL/SQL

  3. Forms

  4. Reports


Correct Option: D

Which of the following statements will change the data in the table?

  1. Delete statement

  2. Insert statement

  3. Update statement

  4. All the above

  5. None of these


Correct Option: D
Explanation:

Yes, Delete, Insert and Update change the data in the table.

In a customer database, a customer’s surname would be keyed into ____.

  1. a row

  2. a text field

  3. a record

  4. a computed field

  5. None of these


Correct Option: C
Explanation:

In a customer database, a customer’s surname would be keyed into a record.

- Hide questions