WorksheetsDatabase concepts and the Structured Query Language
Total questions: 20
Worksheet time: 10mins
The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B .DDL
C .VDL
D. SDL
The command used to delete a particular column in a relation is ____________
A.UPDATE TABLE
B.TRUNCATE COLUMN
C.ALTER , DROP
D.DELETE COLUMN
Which of the following operations requires the relations to be union compatible?
A.UNION
B.INTERSECTION
C.DIFFERENCE
D.ALL OF THESE
The database language that allows us to access data in a database is called :
A.DCL
B.DML
C.DDL
D.None Of Above
Which data manipulation command is used to combines the records from one or more tables?
A.SELECT
B.PROJECT
C.JOIN
D.PRODUCT
Which of the following is a legal expression in SQL?
A.SELECT NULL FROM SALES;
B.SELECT NAME FROM SALES;
C.SELECT * FROM SALES WHEN PRICE = NULL;
D.SELECT # FROM SALES;
DCL provides commands to perform actions like
A.Change the structure of Tables
B.Insert, Update or Delete Records and Values
C.Authorizing Access and other control over Database
D.None of Above
Which data type can store unstructured data in a column?
A.RAW
B.CHAR
C.NUMERIC
D.VARCHAR
The virtual table that its created by data from the result of an SQL 'Select' statement is called _________
A.View
B.Synonym
C.Sequence
D.Transaction
What is the full form of DDL ?
A.Dynamic Data Language
B.Detailed Data Language
C.Data Definition Language
D.Data Derivation Language
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
A. 6789
B. 2345
C. 1234
D. 456789
The SQL statementSELECT ROUND(45.926, -1) FROM DUAL;
A. is illegal
B. prints garbage
C. prints 045.926
D. prints 50
Find all the cities whose humidity is 89
A. SELECT city WHERE humidity = 89;
B. SELECT city FROM weather WHERE humidity = 89;
C. SELECT humidity = 89 FROM weather;
D. SELECT city FROM weather;
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance
Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
c) Tuple, Relation
The “father” of MySQL is ______.
A. Michael Widenius
B. Bill Joy
C. Bill Gates
D. Stephanie Wall
E. Sigmund Velin
MySQL runs on which operating systems?
A. Unix and Linux only
B. Linux and Mac OS-X only
C. Unix, Linux, Windows and others
D. Any operating system at all
Which of the following is NOT supported by MySQL?
A. Temporary (Hash) Tables
B. Table Joining
C. Stored Procedures
D. Regular Expression Matching
Which of these field types would be best to hold a .jpg image?
A. char binary
B. nchar binary
C. text
D. blob
