0

databases Online Quiz - 58

Description: databases Online Quiz - 58
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' ;

  2. SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson';

  3. SELECT FirstName='Peter', LastName='Jackson' FROM Persons

  4. SELECT FirstName LIKE 'Peter', LastName LIKE 'Jackson' FROM Persons


Correct Option: A
  1. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

  2. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' ;

  3. SELECT LastName>'Hansen' AND LastName

  4. SELECT LastName LIKE'%Hansen%' AND LastName LIKE '%Pettersen%' FROM Persons ;


Correct Option: B
  1. INSERT ('Jimmy', 'Jackson') INTO Persons ;

  2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons ;

  3. INSERT INTO Persons VALUES ('Jimmy', 'Jackson') ;

  4. INSERT VALUES ('Jimmy', 'Jackson') INTO Table Persons ;


Correct Option: C
  1. INSERT INTO Persons ('Olsen') INTO LastName ;

  2. INSERT INTO Persons (LastName) VALUES ('Olsen');

  3. INSERT ('Olsen') INTO Persons (LastName) ;

  4. INSERT INTO Table Persons (LastName) VALUES ('Olsen');


Correct Option: B
  1. SELECT Persons.FirstName ;

  2. EXTRACT FirstName FROM Persons ;

  3. SELECT FirstName FROM Persons;

  4. EXTRACT Persons.FirstName


Correct Option: C
  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT UNIQUE

  4. All of the above


Correct Option: B
  1. Structured Query Language

  2. Strong Question Language

  3. Structured Question Language

  4. None of the Above


Correct Option: A

Which of the following does not hold true for the subqueries?

  1. Can be the object of an IN or NOT IN clause

  2. Can be the object of EXISTS or NOT EXISTS

  3. Support quantifiers ALL, ANY, SOME

  4. Support LIKE or NOT LIKE used with a

  5. Cannot specify more than one column to match


Correct Option: E

Which of the following is not a DDL statement?

  1. CREATE

  2. DROP

  3. MODIFY

  4. ALTER

  5. GRANT

  6. REPLACE


Correct Option: E
  1. SELECT DISTINCT position, manager

  2. SELECT position, manager DISTINCT

  3. SELECT position, manager

  4. SELECT position, DISTINCT manager


Correct Option: A
  1. SQL*Plus commands cannot be abbreviated.

  2. SQL*Plus commands are accesses from a browser.

  3. SQL*Plus commands are used to manipulate data in tables.

  4. SQL*Plus commands manipulate table definitions in the database.


Correct Option: C,D
  1. Insert

  2. update

  3. select

  4. describe

  5. delete

  6. rename


Correct Option: D
  1. The sort is in ascending by order by default

  2. The sort is in descending order by default

  3. The ORDER BY clause must precede the WHERE clause.

  4. The ORDER BY clause is executed on the client side.

  5. The ORDER BY clause comes last in the SELECT statement.

  6. The ORDER BY clause is executed first in the query execution.


Correct Option: A,E

Evaluate this SQL*Plus command: START delaccount Which task will this command accomplish?

  1. It executes the DELACCOUNT PL/SQL routine.

  2. It runs the DELACCOUNT.SQL script file.

  3. It creates the DELACCOUNT file using the default file extension.

  4. It invokes the editor to edit the contents of the DELACCOUNT file.


Correct Option: B
  1. Substitution variables

  2. Replacement variables

  3. Prompt variables

  4. Instead-of variables


Correct Option: A
- Hide questions