Introduction to SQL - General Questions Online Exam Quiz
Introduction to SQL - General Questions GK Quiz. Question and Answers related to Introduction to SQL - General Questions. MCQ (Multiple Choice Questions with answers about Introduction to SQL - General Questions
You can add a row using SQL in a database with which of the following?
Options
A : ADD
B : CREATE
C : INSERT
D : MAKE
The command to remove rows from a table 'CUSTOMER' is:
Options
A : REMOVE FROM CUSTOMER ...
B : DROP FROM CUSTOMER ...
C : DELETE FROM CUSTOMER WHERE ...
D : UPDATE FROM CUSTOMER ...
The SQL WHERE clause:
Options
A : limits the column data that are returned.
B : limits the row data are returned.
C : Both A and B are correct.
D : Neither A nor B are correct.
Which of the following is the original purpose of SQL?
Options
A : To specify the syntax and semantics of SQL data definition language
B : To specify the syntax and semantics of SQL manipulation language
C : To define the data structures
D : All of the above.
The wildcard in a WHERE clause is useful when?
Options
A : An exact match is necessary in a SELECT statement.
B : An exact match is not possible in a SELECT statement.
C : An exact match is necessary in a CREATE statement.
D : An exact match is not possible in a CREATE statement.
A view is which of the following?
Options
A : A virtual table that can be accessed via SQL commands
B : A virtual table that cannot be accessed via SQL commands
C : A base table that can be accessed via SQL commands
D : A base table that cannot be accessed via SQL commands
The command to eliminate a table from a database is:
Options
A : REMOVE TABLE CUSTOMER;
B : DROP TABLE CUSTOMER;
C : DELETE TABLE CUSTOMER;
D : UPDATE TABLE CUSTOMER;
ON UPDATE CASCADE ensures which of the following?
Options
A : Normalization
B : Data Integrity
C : Materialized Views
D : All of the above.
SQL data definition commands make up a(n) ________ .
Options
A : DDL
B : DML
C : HTML
D : XML
Which of the following is valid SQL for an Index?
Options
A : CREATE INDEX ID;
B : CHANGE INDEX ID;
C : ADD INDEX ID;
D : REMOVE INDEX ID;
Advanced SQL - General Questions more Online Exam Quiz
Database Redesign - General Questions
Data Modeling with ER Model - General Questions
Data Warehousing - General Questions
Distributed Databases - General Questions
Introduction to Database - General Questions
JDBC, Java Server Pages, and MySQL - General Questions
Logical Database Design - General Questions
Managing Databases with Oracle - General Questions