Top 1000+ Database Subject Mcqs Pdf Download Set No 09
401.A hierarchical data model is :
- Partially ordered
- Not ordered
- Totally ordered
- Concept of ordering does not appear
402.A form defines :
- where data is placed on the screen
- the width of each field
- both [A] and [B]
- all
403.The designer of a form includes :
- Field designators
- Prompts
- Data
- Both [A] and [B]
404.UPDATE command belongs to which type of Classification
- DML
- DDL
- DCL
- DQL
405.The _________ function helps reduce the need to use multiple OR conditions.
- IN
- AND
- Like
- Between
406.Which of the flowing clauses allows to sort the records in result set?
- Where
- Order by
- From
- Having
407.In SQL queries, while creating tables or relations in database, key columns may be specified by
- Null
- Not Null
- Data Type
- None
408.Identify the language which is used to specify database schema.
- DCL
- DML
- DDL
- Non
409.Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
- CREATE – to create objects in the database
- ALTER – alters the structure of the database
- DROP – delete objects from the database
- TRUNCATE – remove all records from a table, including all spaces allocated for the records are removed
- COMMENT – add comments to the data dictionary
- RENAME – rename an object
410._______ Operators are the ones that require two operands on both sides of the operator.
- Double
- Tow Sided
- Binary
- None of the given options
411.What happened if the Where clause is omitted from a Delete Statement?
- All record from the table are deleted
- No record from the tables will be deleted
- First record of the tables will be deleted
- The statement will not be executed and will give a syntax error
412.Which of the following is a String function in SQL
- Count
- LEN
- SQRT
- SIN
413.Revoke is a __________ Statement
- Data Definition
- Control Access
- Data Manipulation
- Data Description
414.Truncate command response time is ____ as compared to Delete command.
Select correct option:
- Poor
- Same
- Better
- worst
415.Which of the following syntax of the functions in SQL is used to add column values?
Select correct option:
- COUNT(*)
- COUNT(expression)
- MAX(expression)
- SUM(expression)
416.SQL is used for:
Select correct option:
- Creating, managing and deleting tables and manage the relationships among the stored date.
- Generating queries, organizing, managing and retrieving data stored in a database.
- Maintaining data integrity and coordinate data sharing.
- All
417.Which of the following is used to filter rows according to some condition(s)?
Select correct option:
- SELECT
- FROM
- WHERE
- UPDATE
418.Which language is used to permit or prohibit access to a table?
Select correct option:
- DCL
- DDL
- DML
- All .
419.Which of the following is used to filter rows according to some condition(s)?
Select correct option:
- SELECT
- FROM
- WHERE
- UPDATE
420.Which language is used to permit or prohibit access to a table?
Select correct option:
- DDL
- DML
- All .
- DCL
421.Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.
Select correct option:
- True
- FALSE
422.Which of the following is NOT a DDL command?
Select correct option:
- Delete
- Create DB
- Create table
- Drop
423.Which of the following function falls in the category of Aggregate functions.
Select correct option:
- MIN
- M SUM
- MAX
- All
424.Value of a function in SQL is always determined by the input parameters
- FALS
- TRUE
425.in “One to Many” cardinality one instance of a relation is mapped with
Select correct option:
- many instances of second entity type
- One instance of second entity type
- Primary key of 2 relations
- none
426.A second Normal Form (2 NF) relation should
- Select correct option:
- not have a composite key
- not have attributes dependent on key attribute
- not have attributes dependent on one another
- be in 1 NF
427.Normalization of database is essential to
- avoid accidental deletion of required data when some data is deleted
- eliminate inconsistencies when a data item is modified in the database
- allows storage of data in a computer’s disk
- use a database management system
428. Select correct option:
- i and iii
- i and ii
- ii and iii
- ii and iv
429.A relation which is in a higher normal form
Select correct option:
- implies that it also qualifies to be in lower normal form
- does not necessarily satisfy the conditions of lower normal form
- is included in the lower normal form
- is independent of lower normal forms
430.“Unary relationship” is one which involves
Select correct option:
- Single entity
- Two entities
- Many entities
- No entity
431.An attribute y may be functionally dependent on
(i) a composite attribute x,y
(ii) a single attribute x (iii) no attribute
Select correct option:
- i and ii
- i and iii
- ii and iii
- iii
432.in “One to One Relationship” One instance of first entity type is mapped with two instances of second entity type
Select correct option:
- true
- false
433.DML perform functions such as
Select correct option:
- Insertion
- Deletion
- Creation of database
- All
434.“Select” and “project” are the examples of
Select correct option:
- Unary operations
- Binary operations
- All
- D. Ternary operations
435.identify the basic part(s) of a SELECT statement?
- SELECT
- FROM
- Both SELECT and FROM
- DISTINCT
436. Which of the following SQL statements used to control access to the data and to the database?
Select correct option:
- GRANT
- REVOKE
- Both GRANT and REVOKE
- SELECT
437.GRANT is a ______________ Command.
Select correct option:
- DDL
- DML
- DCL
- None
438.Is the given SQL Statement prompt error? Select * from relation1;
Select correct option:
- Logical Error
- No Error
- Parameter Error
- Time out Error
439.Consider a table named “employee” having fields Employee name, Employee ID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM employee WHERE Emp name=’ALI’;
Select correct option:
- The statement has a syntax error
- The statement only displays the Employee ID of those employees whose name is ALI
- The statement displays the entire fields from Employee in which the Employee name is ALI
- The statement must have an ORDERBY clause
440.Consider the two relations, Supplier (S no, S name, Contact No, Address) and Supply (S no, Item no). Which of the following statements give(s) a list of supplier names supplying the item with Item no ‘555’?
- Select correct option:
- SELECT S name FROM Supplier WHERE Item no=’555’
- SELECT S name FROM Supplier, Supply WHERE Supplier S no=Supply S no AND Item no=’555’
- SELECT S name FROM Supplier WHERE S no EXISTS (SELECT S_no FROM Supply WHERE Item no=’555’)
- SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no=’555′)
441.Which of the following is the correct syntax for adding a new column into an existing table.
Select correct option:
- ALTER TABLE table name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
- ALTER TABLE table name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
- Both I and II.
- None .
442. DML does not used to :
Select correct option:
- add new rows to tables
- alter a table definition
- retrieve rows from table
- modify the rows of tables
443.Objective of an order by clause is to display or arrange output of a select statement in a particular order.
Select correct option:
- True
- False
444.Which of the following is not DML command?
Select correct option:
- Select
- Update
- Delete
- Truncate
445.Which of the following is incorrect about alter table statement?
Select correct option:
- Cannot be used to modify type or size of an existing column
- Can be used to delete a column
- Can not be used to create a new table
- Can be used to add column in the existing tablet.
446.Which of the following is used with INSERT command to insert values in a DB table?
Select correct option:
- ONTO
- UPTO
- WITH
- INTO
447.Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Select correct option:
- SELECT FROM * Persons
- SELECT * FROM Persons
- SELECT * WHERE Persons
- SELECT WHERE * Persons
448.The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:
- IN
- FROM
- LIKE
- None .
449.Which of the following statements creates a database named IMDB.
Select correct option:
- CREATE DATABASE IMDB;
- CREATE DB IMDB;
- ADD DATABASE named IMDB;
- CREATE IMDB DATABASE;
450.Which of the following is not true regarding clustering?
Select correct option:
- It increases the efficiency since related records are placed close to each other
- Clustering makes records, difficult to access
- suitable to relatively static situations.
- It is a process, which means to place records from different tables to place in adjacent physical locations