شعبي ميوزك: Database Management System

‏إظهار الرسائل ذات التسميات Database Management System. إظهار كافة الرسائل

Solved MCQ on Database Backup and Recovery in DBMS set-1

1) Which of the following is not a recovery technique?

A. Deferred update

B. Immediate update

C. Two-phase commit

D. Recovery management

2)Checkpoints are a part of

A. Recovery measures

B. Security measures

C. Concurrency measures

D. Authorization measures

3) ....... deals with soft errors, such as power failures.

A. system recovery

B. media recovery

C. database recovery

D. failure recovery

4) ........... is an essential part of any backup system.

A. Filter

B. Recovery

C. Security

D. Scalability

5) Media recovery deals with ...........

A. disk errors

B. hard errors

C. system errors

D. power failures

6) For a backup/restore system, ............. is a prerequisite for service in a enterprise.

A. Filter

B. Recovery

C. Security

D. Scalability

7) Failure recovery and media recovery fall under ........

A. transaction recovery

B. database recovery

C. system recovery

D. value recovery

8) The .......... consists of the various applications and database that play a role in a backup and recovery strategy.

A. Recovery Manager environment

B. Recovery Manager suit

C. Recovery Manager file

D. Recovery Manager database

9) In which the database can be restored up to the last consistent state after the system failure?

A. Backup

B. Recovery

C. Both

D. None

10) A ........... is a block of Recovery Manager(RMAN)job commands that is stored in the recovery catalogue.

A. recovery procedure

B. recovery block

C. stored block

D. stored script

11) In log based recovery, the log is sequence of .........

A. filter

B. records

C. blocks

D. numbers

12) The enrolling of a database in a recovery catalogue is called .........

A. set up

B. registration

C. start up

D. enrolment

13) .......... is an alternative of log based recovery.

A. Disk recovery

B. Shadow paging

C. Dish shadowing

D. Crash recovery

14) Most backup and recovery commands in ........... are executed by server sessions.

A. Backup Manager

B. Recovery Manager

C. Backup and Recovery Manager

D. Database Manager

15) ........ systems typically allows to replace failed disks without stopping access to the system.

A. RAM

B. RMAN

C. RAD

D. RAID

16) An ......... is an exact copy of a single datafile, archived redo log file, or control file.

A. image copy

B. datafile copy

C. copy log

D. control copy

17) .......... known as memory-style error correcting-code(ECC) organization, employs parity bits.

A. RAID level 1

B. RAID level 2

C. RAID level 3

D. RAID level 4

18) The remote backup site is sometimes called the .......... site.

A. primary

B. secondary

C. ternary

D. None of the above

19) EXP command is used ...........

A. to take Backup of the Oracle Database

B. to import data from the exported dump file

C. to create Rollback segments

D. to create Schedule.

20) The simplest approach to introducing redundancy is to duplicate every disk is called .....

A. mirroring

B. imaging

C. copying

D. All of the above

Answers:

1) C. Two-phase commit

2) A. Recovery measures

3) D. failure recovery

4) C. Security

5) A. disk errors

6) D. Scalability

7) C. system recovery

8) A. Recovery Manager environment

9) B. Recovery

10) D. stored script

11) B. records

12) B. registration

13) B. Shadow paging

14) B. Recovery Manager

15) D. RAID

16) A. image copy

17) B. RAID level 2

18) B. secondary

19) A. to take Backup of the Oracle Database

20) A. mirroring

For other more Multiple Choice Questions (MCQs): Click Here

Solved MCQ on Distributed Database Transaction Management set-4

1) Commit and rollback are related to ..........

A. data integrity

B. data consistency

C. data sharing

D. data security

2) The transaction wants to edit the data item is called as .......

A. Exclusive Mode

B. Shared Mode

C. Inclusive Mode

D. Unshared Mode

3) For committing a transaction, the DBMS might discard all the records.

A. after image

B. before image

C. log

D. redo log

4) A sophisticated locking mechanism known as 2-phase locking which includes Growing phase and .......

A. Shrinking Phase

B. Release phase

C. Commit phase

D. Acquire Phase

5) A Transaction ends

A. only when it is Committed.

B. only when it is Rolled-back

C. when it is Committed or Rolled-back

D. only when it is initialized

6) In .........., each transactions there is a first phase during which new lock are acquired.

A. Shrinking Phase

B. Release phase

C. Commit phase

D. Growing Phase

7) A transaction processing system is also called as .......

A. processing monitor

B. transaction monitor

C. TP monitor

D. monitor

8) The transactions are always ......... if it always locks a data item in shared mode before reading it.

A. well formed

B. well distributed

C. well locked

D. well shared

9) .......... servers which is widely used in relational database systems.

A. Data servers

B. Transaction servers

C. Query servers

D. Client servers

10) If a distributed transactions are well-formed and 2-phasedlocked, then ................ is the correct locking mechanism in distributed transaction as well as in centralized databases.

A. two phase locking

B. three phase locking

C. transaction locking

D. well-formed locking

11) ......... property will check whether all the operation of a transaction completed or none.

A. Atomicity

B. Consistency

C. Isolation

D. Durability

12) The total ordering of operations across groups ensures ...........of transactions.

A. serializability

B. synchronizability

C. atomicity

D. durability

13) In which state, the transaction will wait for the final statement has been executed?

A. Active

B. Failed

C. Aborted

D. partially committed

14) The ORDER concurrency control technique is based on the property.

A. ordering mechanism

B. inherent ordering

C. total ordering

D. partial ordering

15) Transactions per rollback segment is derived from .....

A. Db_Block_Buffers

B. Processes

C. shared_Pool_size

D. buffers

16) The ............is responsible for ensuring correct execution in the presence of failures.

A. Database Manager

B. Transaction Manager

C. Recovery Manager

D. Executive Manager

17) A distributed transaction can be ............. if queries are issued at one or more nodes.

A. fully read-only

B. partially read-only

C. fully read-write

D. partially read-write

18) The distributed transaction can be completely read-only and the transaction is started with a .......... READ ONLY statement.

A. DISTRIBUTED_TRANSACTIONS

B. TRANSACTION

C. SET TRANSACTION

D. READ TRANSACTION

19) The initialization parameter ................. controls the number of possible distributed transactions in which a given instance can concurrently participate, both as a client and a server.

A. DISTRIBUTED_TRANSACTIONS

B. TRANSACTION

C. SET TRANSACTION

D. CONTROL TRANSACTION

20) A database administrator can manually force the COMMIT or ROLLBACK of a local ............ distributed transaction.

A. in-force

B. in-doubt

C. in-local

D. in-manual

Answers:

1) B. data consistency

2) A. Exclusive Mode

3) B. before image

4) A. Shrinking Phase

5) C. when it is Committed or Rolled-back

6) D. Growing Phase

7) C. TP monitor

8) A. well formed

9) B. Transaction servers

10) A. two phase locking

11) A. Atomicity

12) A. serializability

13) D. partially committed

14) C. total ordering

15) B. Processes

16) A. Database Manager

17) B. partially read-only

18) C. SET TRANSACTION

19) A. DISTRIBUTED_TRANSACTIONS

20) B. in-doubt

For other more Multiple Choice Questions (MCQs): Click Here

Solved MCQ on Oracle Distributed Transaction set-3

1) A mechanism which ensures that simultaneous execution of more than one transaction does not lead to any database inconsistencies is called .................. mechanism.

A. transaction control

B. transaction management

C. concurrency parallelism

D. concurrency control

2) The transaction wants only to read the data item of mode is called as .......

A. Exclusive Mode

B. Shared Mode

C. Inclusive Mode

D. Unshared Mode

3) Any execution of a set of transactions is called as its .........

A. non-serial schedule

B. serial schedule

C. schedule

D. interleaved schedule

4) ............ is program or set of program that interacts with the database at some point in its execution.

A. A database system

B. A database application

C. Both

D. none

5) .......... component of a database is responsible for ensuring atomicity and durability.

A. recovery management

B. concurrency control

C. storage management

D. query evaluation engine

6) The activity of ensuring atomicity in the presence of Transaction aborts is called ..........

A. transaction control

B. transaction management

C. transaction recovery

D. concurrency control

7) A .............is a set of rules that state when a transaction may lock or unlock each of the data items in the database

A. concurrency control

B. transaction control

C. validation control

D. locking protocol

8) .................. is a collection of programs performing all necessary action associated with a database.

A. Database associated

B. Database administrator

C. Database application

D. Database management system

9) Which protocol permits release of exclusive locks only at the end of transaction?

A. Graph based protocol

B. Strict two phase locking protocol

C. Two phase locking protocol

D. Rigorous Two phase locking protocol

10) The activity of providing Durability of the transaction is called .....

A. database control

B. transaction management

C. transaction recovery

D. database recovery

11) Which protocol allows a transaction to lock a new data item only if that transaction has not yet unlocked data item?

A. Graph based protocol.

B. Strict two phase locking protocol

C. Two phase locking protocol

D. Time stamp ordering scheme

12) .......... is a collection of application programs that interacts with the database along with DBMS.

A. A database system

B. A database application

C. Database administration

D. Data system

13) ........ ensures that once transaction completes successfully, the results of the operations become permanent.

A. serializability

B. synchronizability

C. atomicity

D. durability

14) A ....... contains information for undoing or redoing all the actions performed by the transactions.

A. save point

B. log

C. node

D. commit_point

15) A ............. is a unit of program execution that accesses and possibly updates various data items.

A. DBMS

B. monitor

C. transaction

D. transistor

16) Transaction is an action used to perform some manipulation on data stored in the ........

A. Memory

B. Record

C. Database

D. All of these

17) A transaction is terminated if it has ........

A. aborted

B. committed

C. running state

D. aborted or committed

18) The two possible communication errors are, Lost messages and .......

A. Network Partitions

B. Lost acknowledgement

C. Timeout

D. log error

19) The only way to undo the effects of a committed transaction is to execute a .......

A. committed transaction

B. compensating transaction

C. supplementary transaction

D. update query

20) In .........., one or more users/programs attempt to access the same data at the same time.

A. concurrency

B. transaction control

C. locking

D. two phase locking

Answers:

1) D. concurrency control

2) B. Shared Mode

3) C. schedule

4) B. A database application

5) A. recovery management

6) C. transaction recovery

7) D. locking protocol

8) D. Database management system

9) B. Strict two phase locking protocol

10) D. database recovery

11) C. Two phase locking protocol

12) A. A database system

13) D. durability

14) B. log

15) C. transaction

16) C. Database

17) C. running state

18) A. Network Partitions

19) B. compensating transaction

20) A. concurrency

For other more Multiple Choice Questions (MCQs): Click Here

Solved MCQ on Transaction Management in DBMS set-2

1) In the ............, one transaction inserts a row in the table while the other transaction is half way through its browsing of table.

A. transaction read problem

B. one way read problem

C. serial read problem

D. phantom read problem

2) Transaction processing is associated with everything below except.

A. producing detail, summery, or exception reports

B. recording a business activity

C. confirming an action or triggering a response

D. maintaining data

3) .......... helps solve concurrency problem.

A. locking

B. transaction monitor

C. transaction serializability

D. two phase commit

4) If a transaction acquires a shared lock, then it can perform .......... operation.

A. read

B. write

C. read and write

D. update

5) If a transaction obtains a shared lock on a row, it means that the transaction wants to ..... that row.

A. write

B. insert

C. execute

D. read

6) The node where the distributed transaction originates is called the .......

A. local coordinator

B. starting coordinator

C. global coordinator

D. originating node

7) If a transaction obtains an exclusive lock on a row, it means that the transaction wants to ....... that row.

A. select

B. update

C. view

D. read

8) If a transaction acquires exclusive lock, then it can perform .......... operation.

A. read

B. write

C. read and write

D. update

9) ........ is a specific concurrency problem wherein two transactions depend on each other for something.

A. phantom read problem

B. transaction read problem

C. deadlock

D. locking

10) If a database server is referenced in a distributed transaction, the value of its commit point strength determines which role it plays in the .........

A. two phase commit

B. two phase locking

C. transaction locking

D. checkpoints

11) Transaction .......... ensures that the transaction are being executed successfully.

A. concurrency

B. consistency

C. serialisability

D. non serialiasability

12) The situation in which a transaction holds a data item and waits for the release of data item held by some other transaction, which in turn waits for another transaction, is called .......

A. serialiable schedule

B. process waiting

C. concurrency

D. deadlock

13) ............ protocol grantees that a set of transactions becomes serialisable.

A. two phase locking

B. two phase commit

C. transaction locking

D. checkpoints

14) The global coordinator forgets about the transaction phase is called .........

A. Prepare phase

B. Commit phase

C. Forget phase

D. Global phase

15) In two phase commit, .......... coordinates the synchronization of the commit or rollback operations.

A. database manager

B. central coordinator

C. participants

D. concurrency control manager

16) In two-phase locking protocol, a transaction obtains locks in ........phase.

A. shrinking phase

B. growing phase

C. running phase

D. initial phase

17) A transaction processing system is also called as ........

A. processing monitor

B. transaction monitor

C. TP monitor

D. monitor

18) After the nodes are prepared, the distributed transaction is said to be ......

A. in-doubt

B. in-prepared

C. prepared transaction

D. in-node

19) In .........., we have many mini transactions within a main transaction.

A. transaction control

B. chained transaction

C. nested transaction

D. calling transaction

20) In a two-phase locking protocol, a transaction release locks in ......... phase.

A. shrinking phase

B. growing phase

C. running phase

D. initial phase

Answers:

1) D. phantom read problem

2) C. confirming an action or triggering a response

3) A. locking

4) A. read

5) D. read

6) C. global coordinator

7) B. update

8) C. read and write

9) C. deadlock

10) A. two phase commit

11) C. serialisability

12) D. deadlock

13) A. two phase locking

14) C. Forget phase

15) B. central coordinator

16) B. growing phase

17) C. TP monitor

18) A. in-doubt

19) B. chained transaction

20) A. shrinking phase

For other more Multiple Choice Questions (MCQs): Click Here

Solved MCQ on Distributed Transaction Management set-1

1) If the transaction is rolled back, all the database changes made inside the transaction are ......

A. made permanent

B. made temporary

C. copied to the log

D. undone

2) Which of the following is not a property of transactions?

A. Atomicity

B. Concurrency

C. Isolation

D. Durability

3) A ......... ensures that transactions are performed as expected.

A. transaction processing monitor

B. transaction procedure monitor

C. isolation monitor

D. transaction log

4) A transaction that completes its execution successfully is said to be .......

A. committed

B. rolled back

C. partially committed

D. Aborted

5) ........ means that a transaction must execute exactly once completely or not at all.

A. durability

B. consistency

C. atomicity

D. isolation

6) Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

A. It will result in a deadlock situation

B. It will immediately be rejected

C. It will immediately be granted

D. It will be granted as soon as it is released by A

7) ........... means that when it ends, a transaction must leave the database in a consistent state.

A. Data isolation

B. Data duration

C. Data consistency

D. Data non-reputability

8) The number of transactions executed in a given amount of time is called .........

A. utilization

B. execution rate

c. throughput

D. atomicity

9) Isolation means ......

A. transaction must not interfere with each other

B. transaction must interfere with each other

C. transaction must be in consistent state

D. transaction must be executed immediately

10) Which of the following ensures the atomicity of the transaction?

A. Transaction management component of DBMS

B. Application Programmer

C. Concurrency control component of DBMS

D. Recovery management component of DBMS

11) ........ means that a transaction must make its changes permanent to the database ends.

A. isolation

B. locking

C. durability

D. consistency

12) Throughput means

A. number of transactions that are committed in one hour

B. number of operations in a transaction

C. number of transaction that can be aborted in a given amount of time

D. number of transaction that can be executed in a given amount of time

13) ........ deals with individual transactions.

A. isolate transactions

B. transaction recovery

C. system recovery

D. media recovery

14) The part of a database management system which ensures that the data remains in a consistent state is

A. authorization and integrity manager

B. buffer manager

C. transaction manager

D. file manager

15) ......... protocol is used to perform multiple transactions that execute on different database.

A. commit

B. two phase lock

C. two phase commit

D. locking

16) A transaction can do read and write operation on a data item when it acquires ......

A. read mode

B. exclusive mode

C. shared mode

D. write mode

17) In .......... one transaction overwrites the changes of another transaction.

A. uncommitted read problem

B. lost update problem

C. update lost problem

D. dirty read problem

18) Isolation of the transactions is ensured by

A. Transaction management

B. Application programmer

C. Concurrency control

D. Recovery management

19) In dirty read problem .......

A. one transaction reads an uncommitted value of another transaction

B. one transaction reads the committed value for another transaction

C. one transaction reads another transaction

D. one transaction commits another transaction.

20) A transaction can do only read operation and not write operation on a data item when it acquires ....... lock.

A. read mode

B. exclusive mode

C. shared mode

D. write mode

Answers:

1) D. undone

2) B. Concurrency

3) A. transaction processing monitor

4) A. committed

5) C. atomicity

6) C. It will immediately be granted

7) C. Data consistency

8) c. throughput

9) A. transaction must not interfere with each other

10) A. Transaction management component of DBMS

11) C. durability

12) D. number of transaction that can be executed in a given amount of time

13) B. transaction recovery

14) C. transaction manager

15) C. two phase commit

16) B. exclusive mode

17) B. lost update problem

18) C. Concurrency control

19) A. one transaction reads an uncommitted value of another transaction

20) C. shared mode

For other more Multiple Choice Questions (MCQs): Click Here

Solved MCQ Questions on Structured Query Language set-6

1) ......keyword is used to eliminate the duplicates.

A. distinct

B. unique

C. union

D. intersect

2) ..........is a query that has another query embedded within it.

A. sub query

B. structured query

C. nested query

D. sequence query

3) Which of the following is not an aggregate operator?

A. MAX

B. MIN

C. TOTAL

D. AVG

4) Any SQL statement inside an embedded SQL program must be inside the boundaries of ....

A. EXE SQL and END

B. EXEC SQL and END

C. EXEC and END-EXEC

D. EXEC SQL and END-EXEC

5) In embedded SQL, the per-compiler translates the SQL statements inside the code blocks into the appropriate ....

A. PL/SQL block

B. SQL * plus

C. 3GL statements

D. equivalent C code blocks

6) ........ accepts multiple rows a SQL query, stores them and hands over them one by one to the 3GL program.

A. database program

B. database cursor

C. database object

D. database constraints

7) The ........... is useful in the case of online application.

A. embedded SQL

B. PL/SQL

C. static SQL

D. dynamic SQL

8) What is the Role of revoke command?

A. To give privilege

B. To get back privilege

C. To execute the query

D. To run the program

9) The clause ALTER TABLE in SQL can be used to

A. add an attribute

B. delete an attribute

C. alter the default values of an attribute

D. all of the above

10) Which of the following operations need the participating relations to be union compatible?

A. UNION

B. INTERSECTION

C. DIFFERENCE

D. All of the above

11) ........ is a virtual table that draws its data from the result of an SQL SELECT statement.

A. View

B. Synonym

C. Sequence

D. Transaction

12) In SQL, which of the following is not a data definition language commands?

A. RENAME

B. REVOKE

C. GRANT

D. UPDATE

13) 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 above

14) Which command will delete all data from a table and will not write to the rollback segment?

A. DROP

B. DELETE

C. CASCADE

D. TRUNCATE

15) Which is not part of the Data Definition Language?

A. CREATE

B. ALTER

C. ALTER SESSION

D. CREATE SESSION

16) What operator tests column for the adsence of data?

A. IS Null operator

B. ASSIGNMENT operator

C. LIKE operator

D. NOT operator

17) NOT BETWEEN 10 AND 20 ......

A. displays NULL values

B. does not display NULL values

C. may display NULL values

D. display values

18) Which of the following SQL commands can be used to add data to a database table?

A. ADD

B. UPDATE

C. APPEND

D. INSERT

19) ........ can be used to retrieve data from multiple table.

A. Embedded SQL

B. Dynamic SQL

C. Joins

D. Views

20) .......... privides option for entering SQL queries at execution time, rather than at the development stage.

A. PL/SQL

B. SQL * Plus

C. SQL

D. Dynamic SQL

Answers:

1) A. distinct
2) C. nested query
3) C.TOTAL
4) D. EXEC SQL and END-EXEC
5) C. 3GL statements
6) B. database cursor
7) D. dynamic SQL
8) B. To get back privilege
9) D. all of the above
10) D. All of the above
11) A. View
12) D. UPDATE
13) A. ALTER TABLE
14) B. DELETE
15) C. ALTER SESSION
16) A. IS Null operator
17) B. does not display NULL values
18) D. INSERT
19) C. Joins
20) D. Dynamic SQL

For More Database Management System(DBMS) MCQs: Click Here

Solved Objective Questions on SQL and Embedded SQL set-5

1) DROP is a ................ statement in SQL.

A. Query

B. Embedded SQL

C. DDL

D. DCL

2) The keyword to eliminate duplicate rows from the query result in SQL is.

A. DISTINCT

B. NO DUPLICATE

C. UNIQUE

D. None of the above

3) Which of the following aggregate function does not ignore nulls in its results?

A. COUNT

B. COUNT(*)

C. MAX

D. MIN

4) In SQL, testing whether a subquery is empty is done using

A. DISTINCT

B. UNIQUE

C. NULL

D. EXISTS

5) ................ operator is used to compare a value to a list of literals values that have been specified.

A. Like

B. Compare

C. Between

D. In

6) The language used in application programs to request data from the DBMS is referred to as the

A. DML

B. DDL

C. VDL

D. SDL

7) The DBMS language component which can be embedded in a program is

A. The data definition language(DDL)

B. The data manipulation language(DML)

C. The database administrator(DBA)

D. A query language

8) A DBMS query language is designed to

A. Support end users who use English-like commands.

B. Support in the development of complex applications software.

C. Specify the structure of a database.

D. All of the above

9) It is possible to define a schema completely using.

A. VDL and DDL

B. DDL and DML

C. SDL and DDL

D. VDL and DML

10) Which of the following is correct.

A. a SQL query automatically eliminates duplicates.

B. SQL permits attribute names to be repeated in the same relation.

C. a SQL query will not work if there are no indexes on the relations.

D. None of these.

11) Which of the following is a comparison operator in SQL?

A. =

B. LIKE

C. BETWEEN

D. All of the above

12) To delete a particular column in a relation the command used is.

A. UPDATE

B. DROP

C. ALTER

D. DELETE

13) The ............ operator is used to compare the value to a list of literals values that that have been specified.

A. BETWEEN

B. ANY

C) IN

D) ALL

14) ............ function divides one numeric expression by another and returns the remainder.

A. POWER

B. MOD

C. ROUND

D. REMAINDER

15) A data manipulation command the combines the record from one or more tables is called.

A) SELECT

B. PROJECT

C. JOIN

D. PRODUCT

16) DDL stands for

A. Data definition language

B. Data description language

C. Data design languages

D. Database dictionary languages.

17) The DDL is used to specify the ........

A. Conceptual schema

B. Internal schema

C. Both

D. None

18) Which is used for data retrieval from the database?

A. DDL

B. DML

C. SDL

D. VDL

19) Which is used to specify the user views and their mappings to the conceptual schema?

A. DDL

B. DML

C. SDL

D. VDL

20) Which command are included in a general purpose programming languages?

A. DDL

B. DML

C. DSL

D. VDL

Answers:

1) C. DDL

2) C. UNIQUE

3) B. COUNT(*)

4) D. EXISTS

5) A. Like

6) A. DML

7) B. The data manipulation language(DML)

8) D. All of the above

9) B. DDL and DML

10) D. None of these.

11) D. All of the above

12) C. ALTER

13) A. BETWEEN

14) B. MOD

15) C. JOIN

16) A. Data definition language

17) A.Conceptual schema

18) B.DML

19) D.VDL

20) B.DML

For More Database Management System(DBMS) MCQs: Click Here

MCQ on Basic SQL Queries with Answers set-1

1. DML is provided for

A) Description of logical structure of database

B) Addition of new structure in the database system.

C) Manipulation & processing of database

D) Definition of physical structure of database system

2.'AS' clause is used in SQL for

A) Selection operation

B) Rename Operation

C) Join operation

D) Projection Operation

3. Count function in SQL returns the number of

A) values

B) distinct values

C) groups

D) columns

4. The statement in SQL which allows to change the definition of a table is

A) Alter

B) Update

C) Cteate

D) Select

5. Which of the following is correct.

A) A SQL query automatically eliminates duplicates

B) SQL permits attribute names to be repeated in the same relation

C) A SQL query will not work if there are no indexes on the relations

D) None of the above

6. Which of the following operation is used if we are interested in only certain columns of a table?

A) PROJECTION

B) SELECTION

C) UNION

D) JOIN

7. Which of the following is a legal expression in SQL?

A) SELECT NULL FROM EMPLOYEE;

B) SELECT NAME FROM EMPLOYEE;

C) SELECT NAME FROM EMPLOYEE WHERE SALARY=NULL;

D) None of the above

8. Which of the following is a valid SQL type?

A) CHARACTER

B) NUMERIC

C) FLOAT

D) All of the above

9. Which command is used to select distinct subject (SUB) from the table (BOOK)?

A) SELECT ALL FROM BOOK

B) SELECT DISTINCT SUB FROM BOOK

C) SELECT SUB FROM BOOK

D) All of the above

10. In SQL, which of the following is not a data definition language commands?

A) RENAME

B) REVOKE

C) GRANT

D) UPDATE

Answers:

1. DML is provided for

C) Manipulation & processing of database

2.'AS' clause is used in SQL for

B) Rename Operation

3. Count function in SQL returns the number of

A) values

4. The statement in SQL which allows to change the definition of a table is

A) Alter

5. Which of the following is correct.

D) None of the above

6. Which of the following operation is used if we are interested in only certain columns of a table?

A) PROJECTION

7. Which of the following is a legal expression in SQL?

B) SELECT NAME FROM EMPLOYEE;

8. Which of the following is a valid SQL type?

D) All of the above

9. Which command is used to select distinct subject (SUB) from the table (BOOK)?

B) SELECT DISTINCT SUB FROM BOOK

10. In SQL, which of the following is not a data definition language commands?

D) UPDATE

Solved MCQ on Database Normalization set-1

1. A ..................... specifies the actions needed to remove the drawbacks in the current design of database.

A) 1 NF

B) 2 NF

C) 3 NF

D) Normal form

2. A relation is in ........................... if an attribute of a composite key is dependent on an attribute of other composite key.

A) 2NF

B) 3NF

C) BCNF

D) 1NF

3. Fifth Normal form is concerned with

A) Functional dependency

B) Multivalued dependency

C) Join dependency

D) Domain key

4. A table is in the ....................... if only candidate keys are the determinants.

A) functional dependency

B) transitive dependency

C) 4 NF

D) BCNF

5. In 2NF

A) No functional dependencies exist.

B) No multivalued dependencies exist.

C) No partial functional dependencies exist

D) No partial multivalued dependencies exist.

6. The normal form that is not necessarily dependency preserving is

A) 2NF

B) 3NF

C) BCNF

D) 4NF

7. The ................. is related to the concept of multi-valued dependency.

A) fourth normal form

B) fifth normal form

C) boyce codd normal form

D) third normal form

8. Which normal form is considered adequate for normal relational database design?

A) 2NF

B) 5NF

C) 4NF

D) 3NF

9. Dependency preservation is not guaranteed in

A) BCNF

B) 3NF

C) 4NF

D) DKNF

10. A relation is ................... if every field contains only atomic values that is, no lists or sets.

A) 1 NF

B) 2 NF

C) 3 NF

D) BCNF

Answers:

1. A ..................... specifies the actions needed to remove the drawbacks in the current design of database.

D) Normal form

2. A relation is in ........................... if an attribute of a composite key is dependent on an attribute of other composite key.

B) 3NF

3. Fifth Normal form is concerned with

C) Join dependency

4. A table is in the ....................... if only candidate keys are the determinants.

D) BCNF

5. In 2NF

C) No partial functional dependencies exist

6. The normal form that is not necessarily dependency preserving is

A) 2NF

7. The ................. is related to the concept of multi-valued dependency.

A) fourth normal form

8. Which normal form is considered adequate for normal relational database design?

D) 3NF

9. Dependency preservation is not guaranteed in

A) BCNF

10. A relation is ................... if every field contains only atomic values that is, no lists or sets.

A) 1 NF

Answers:

Related Posts

For other more Multiple Choice Questions (MCQs): Click Here

Answers:

Related Posts

For other more Multiple Choice Questions (MCQs): Click Here

Answers:

Related Posts

For other more Multiple Choice Questions (MCQs): Click Here

Answers:

Related Posts

For other more Multiple Choice Questions (MCQs): Click Here

Answers:

Related Posts

For other more Multiple Choice Questions (MCQs): Click Here

Answers:

Related Posts:

For More Database Management System(DBMS) MCQs: Click Here

Answers:

Related Posts:

For More Database Management System(DBMS) MCQs: Click Here

Answers:

Related Posts:

Answers:

Related Posts:

فيديو الأسبوع