Database MCQ Number 00867

Database MCQ Set 1

1. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
a) Data Definition Language(DDL)
b) Data Manipulation Language(DML)
c) DML and DDL
d) None of the Mentioned

2. Which of the following is/are the DDL statements?
A) Create
B) Drop
C) Alter
D) All of the Mentioned

3. In SQL, which command(s) is(are) used to change a table’s storage characteristics?
a) ALTER TABLE
b) MODIFY TABLE
c) CHANGE TABLE
d) All of the Mentioned

4. In SQL, which of the following is not a data definition language commands?
a) RENAME
b) REVOKE
c) GRANT
d) UPDATE

5. ________clause is an additional filter that is applied to the result.
a) Select
b) Group-by
c) Having
d) Order by

6. _____ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
a) Column
b) Constraint
c) Index
d) Trigger

7. SQL has how many main commands for DDL:
a) 1
b) 2
c) 3
d) 4

8. Which command defines its columns, integrity constraint in create table:
a) Create command
b) Drop table command
c) Alter table command
d) All of the Mentioned

9. Which command is used for removing a table and all its data from the database:
a) Create command
b) Drop table command
c) Alter table command
d) All of the Mentioned

10. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:
a) TRUNCATE command
b) Create command
c) Drop table command
d) Alter table command

Database MCQ Set 2

1. The language used application programs to request data from the DBMS is referred to as ____
a) DML
b) DDL
c) Query language
d) All of the Mentioned

2. In SQL, which of the following is not a data Manipulation Language Commands?
a) Delete
b) Truncate
c) Update
d) Create

3. Which of the following is not a type of SQL statement?
a) Data Manipulation Language (DML)
b) Data Definition Language (DDL)
c) Data Control Language (DCL)
d) Data Communication Language (DCL)

4. Which of the following is not included in DML (Data Manipulation Language)
a) INSERT
b) UPDATE
c) DELETE
d) CREATE

5. TRUNCATE statement in SQL is a –
a) DML statement
b) DDL statement
c) DCL statement
d) TCL statement

6. In SQL, which command is used to add new rows to a table?
a) Alter Table
b) Add row
c) Insert
d) Append

7. Stack is also called ____
a) First In First Out (LIFO)
b) Last In First Out (FIFO)
c) First In Last Out (FILO)
d) First Come First Served (FCFS)

8. A table that displays data redundancies yields ______ anomalies.
a) Update
b) Insertion
c) Deletion
d) All of the Mentioned

9. A type of query that is placed within a WHERE or HAVING clause of another query is called
a) Master query
b) Sub query
c) Super query
d) Multi-query

10. The three language components of a database management system (DBMS) like DDL, DCL, DML.
Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?
a) DDL
b) DML
c) DDL and DCL
d) DCL and DML

Database MCQ Set 3

1. What is the full form of SQL?
a) Structured Query Language
b) Structured Query List
c) Simple Query Language
d) None of the Mentioned

2. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
a) Data Definition Language(DDL)
b) Data Manipulation Language(DML)
c) DDL and DML
d) None of the Mentioned

3. 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 Mentioned

4. A command that lets you change one or more fields in a record is
a) Insert
b) Modify
c) Look-up
d) All of the Mentioned

5. Which of the SQL statements is correct?
a) SELECT Username AND Password FROM Users
b) SELECT Username, Password FROM Users
c) SELECT Username, Password WHERE Username = ‘user1’
d) None of the Mentioned

6. The SQL statement
SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;
a) 6789
b) 2345
c) 1234
d) 456789

7. Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement

SELECT COUNT(*) FROM Employee WHERE  SALARY > ANY (SELECT SALARY FROM EMPLOYEE);

prints
a) 10
b) 9
c) 5
d) 0

8. Find the temperature in increasing order of all cities
a) SELECT city FROM weather ORDER BY temperature;
b) SELECT city, temperature FROM weather;
c) SELECT city, temperature FROM weather ORDER BY temperature;
d) SELECT city, temperature FROM weather ORDER BY city;

SELECT column_name, aggregate_function(column_name)
	FROM table_name
	WHERE column_name operator value
	GROUP BY column_name
	HAVING aggregate_function(column_name) operator value
	ORDER BY ; 

9. Which of the following is illegal?
a) SELECT SYSDATE – SYSDATE FROM DUAL;
b) SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;
c) SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;
d) None of the Mentioned

10. Let the statement : SELECT column1 FROM myTable; return 10 rows.
The statement : SELECT ALL column1 FROM myTable; will return
a) less than 10 rows
b) more than 10 rows
c) exactly 10 rows
d) none of the Mentioned

Database MCQ Set 4

1. Which of the following wizard provides creation logins on the destination server ?
a) Copy Database
b) Move Database
c) Detach database
d) Attach database

2. Point out the correct statement :
a) After a database has been upgraded, it cannot be downgraded to a previous version.
b) The Copy Database Wizard is available in the Express edition
c) The Copy Database Wizard cannot be used to copy System databases
d) None of the mentioned

3. How many ways are provided by SQL Server to copy a database ?
a) 2
b) 3
c) 4
d) 5

4. Which is not the preferred way of copying a database ?
a) Using the Copy Database Wizard
b) Restoring a database backup
c) Using the Generate Scripts Wizard to publish databases
d) None of the mentioned

5. Point out the wrong statement related to the use of Copy database wizard:
a) Pick a source and destination server
b) System stored procedures
c) Schedule when to move or copy the databases
d) None of the mentioned

6. Which of the following returns a list of the database and log files ?
a) RESTORE FILELISTON
b) RESTORE FILELIST
c) RESTORE FILELISTONLY
d) All of the mentioned

7. Which of the following transfer method makes the database unavailable to users during the transfer ?
a) Detach and attach method
b) SQL Management Object method
c) Restore method
d) None of the mentioned

8. Which of the following stored prcoedure is used for detachment of database ?
a) sp_replicationdboption
b) sp_replicationdb
c) sp_replicationoption
d) All of the mentioned

9. Which of the following code snippet will detach AdventureWorks2012 database ?
a)

USE master;
GO
EXEC xp_detach_db @dbname = N'AdventureWorks2012';
GO

b)

USE master;
GO
EXEC sp_detach @dbname = N'AdventureWorks2012';
GO

c)

USE master;
GO
EXEC sp_detach_db @dbname = N'AdventureWorks2012';
GO

d)

USE master;
GO
EXEC sp_det_db @dbname = N'AdventureWorks2012';
GO

10. Which of the code is valid for attaching the database ?
a)

USE master;
GO
CREATE DATABASE MyAdventureWorks 
    ON (FILENAME = 'C:MySQLServerAdventureWorks2012_Data.mdf'),
    (FILENAME = 'C:MySQLServerAdventureWorks2012_Log.ldf')
    FOR ATTACH;
GO

b)

USE master;
GO
CREATE DATABASE MyAdventureWorks 
    ON (FILENAME = 'C:MySQLServerAdventureWorks2012_Data.mdf'),
    (FILENAME = 'C:MySQLServerAdventureWorks2012_Log.ldf')
    TO ATTACH;
GO

c)

USE master;
GO
CREATE DATABASE MyAdventureWorks 
    ON (FILENAME = 'C:MySQLServerAdventureWorks2012_Data.mdf'),
    (FILENAME = 'C:MySQLServerAdventureWorks2012_Log.ldf')
    FOR ATTACH_DB;
GO

d) None of the mentioned

Database MCQ Set 5

1. The SQL Server Maintenance Solution comprises scripts for running ____ maintenance on all editions of Microsoft SQL Server.
a) backups
b) integrity checks
c) index
d) all of the mentioned

2. Point out the correct statement related to database maintenance :
a) Performing SQL Server Maintenance with Maintenance Window
b) Performing SQL Server Maintenance with No Maintenance Window
c) Performing SQL Server Maintenance with Scrip Maintenance Window
d) None of the mentioned

3. Which of the following is used to determine the fragmentation for tables and indexes ?
a) DBCC SHOWCONTIG
b) DBCC CHECKDB
c) DBCC CHECKCATALOG
d) None of the mentioned

4. Which of the following is used to Validate the database objects ?
a) DBCC SHOWCONTIG
b) DBCC CHECKDB
c) DBCC CATALOG
d) None of the mentioned

5. Point out the wrong statement :
a) The command DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database
b) The command DBCC CHECK checks the logical and physical integrity of all the objects in the specified database
c) The command CHECKDB checks the logical and physical integrity of all the objects in the specified database
d) None of the mentioned

6. Which of the following command defragments clustered and secondary indexes of the specified table ?
a) DBCC SHOWCONTIG
b) DBCC CHECKDB
c) DBCC CATALOG
d) DBCC INDEXDEFRAG

7. ________ runs UPDATE STATISTICS against all user-defined tables in the current database.
a) sp_updatestats
b) DBCC CHECKDB
c) DBCC CATALOG
d) DBCC INDEXDEFRAG

8. Purpose of DBCC DBREINDEX command is to :
a) Rebuilds one or more indexes for a table in the specified database
b) Rebuilds only one index for a table in the specified database
c) Displays fragmentation information for the data and indexes of the specified table
d) All of the mentioned

9. What types of database maintenance should be executed ?
a) Update SQL Server’s usage
b) Validate the database objects and system catalogs are free of corruption
c) Determine the fragmentation for tables and indexes
d) All of the mentioned

10. Create a Database Maintenance Plan that creates a ________ backup within SQL Server.
a) Partial
b) Snapshot
c) Full
d) None of the mentioned

DistPub Team

Distance Publisher (DistPub.com) provide project writing help from year 2007 and provide writing and editing help to hundreds student every year.

• Website
• Twitter
• Facebook