sql

Ques:- The SQL keywords _____ is used with wildcards.
A. NOT in only
B. IN and NOT IN
C. IN only
D. LIKE only

0 8550
Ques:- Which of the following is the original purpose of SQL?
A. To define the data structures
B. To specify the syntax and semantics of SQL data definition language
C. To specify the syntax and semantics of SQL manipulation language
D. All of the above

1 1913
Ques:- Which one of the following sorts rows in SQL?
A. ALIGN BY
B. ORDER BY
C. SORT BY
D. GROUP BY

1 4936
Ques:- SQL data definition commands make up a(n)
A. HTML
B. DML
C. DDL
D. XML

0 8844
Ques:- You can add a row using SQL in a database with which of the following?
A. INSERT
B. CREATE
C. ADD
D. MAKE

0 9573
Ques:- The result of a SQL SELECT statement is a(n)
A. File
B. Report
C. Form
D. Table

1 1182
Ques:- The primary key is selected from the
A. Determinants
B. Candidate keys
C. Composite keys
D. Foreign keys

1 2035
Ques:- A relation is in this form if it is in BCNF and has no multivalued dependencies.
A. Second normal form
B. Third normal form
C. Fourth normal form
D. Domain/key normal form

1 1765
Ques:- SQL can be used to
A. Create database structures only
B. Query database data only
C. Modify database data only
D. All of the above can be done by SQL

1 874
Ques:- SQL query and modification commands make up a(n)
A. DDL
B. HTML
C. XML
D. DML

0 6148
Ques:- The SQL statement that queries or reads data from a table is
A. READ
B. SELECT
C. ORDER
D. QUERY

1 1018
Ques:- The command to eliminate a table from a database is
A. DELETE TABLE CUSTOMER
B. UPDATE TABLE CUSTOMER
C. DROP TABLE CUSTOMER
D. REMOVE TABLE CUSTOMER

1 8135
Ques:- Second normal form should meet all the rules for
A. 1 NF
B. 3 NF
C. 4 NF
D. 5 NF

1 5813
Scroll to top