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 insert new data in a database?
What does SQL stand for?
Which SQL statement is used to return only different values?
With SQL, how can you insert a new record into the "Persons" table?
Which SQL statement is used to delete data from a database?
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
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?
Is the database and DBMS software together is called as Database system?
which of the following are the advantages of DBMS? (Select 2)