databases Online Quiz - 216
Description: databases Online Quiz - 216 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Which SQL statement is used to extract data from a database?
Which SQL statement is used to update data in a database?
Which SQL statement is used to insert new data in a database?
What does SQL stand for?
With SQL, how do you select all the columns from a table named "Persons"?
Which SQL statement is used to return only different values?
With SQL, how can you insert a new record into the "Persons" table?
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
Which SQL statement is used to delete data from a database?
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
Which SQL statement defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?
Evaluate the set of SQL statements: CREATE TABLE dept (deptbi NUMBER (2) dname VARCHAR2(14), Ioc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?
Which two are attributes of /SQL* Plus? (Choose two).
Is the database and DBMS software together is called as Database system?
which of the following are the advantages of DBMS? (Select 2)