SQL Server MCQ Test – 1

Que.1. Can you use the UPDATE and SELECT clauses in one SQL statement?
A.    You can if you use nested SQL statement
B.    You can’t
C.    You can use UPDATE and SELECT clause together, even if you don’t have nested SQL statements

Right Answer: A

Que.2. Can we temporarily disable a login name?
A.    Yes
B.    No

Right Answer: A

Que.3. Permanent setting of specific server characteristics is done by trace tags
A.    False
B.    True

Right Answer: A

Que.4. Which of the following statements is/are false for Extended events in sql server 2008?
A.    Enhanced event handling system in SQL Server
B.    Both b and c below
C.    Used for problem identification or problem trouble shooting
D.    An architecture that is  not very scalable, highly configurable

Right Answer: D

Que.5. When SQL server is installed, which of the following database are created by default?
A.    Master
B.    Model
C.    Both a and b
D.    Root

Right Answer: C

Que.6. Which of the following statements is/are true for SQL server?
A.    SQL Server has Logical Architecture and Physical Architecture
B.    Both a and c
C.    SQL Server is compatible with the structured query language and has rich for XML
D.    SQL Server is a DBMS, a complete database.

Right Answer: B

Que.7. What is the difference between the WHERE and HAVING SQL clauses?
A.    The WHERE and the HAVING clauses are identical
The HAVING SQL clause condition(s) is applied to all rows in the result set before the
B.    WHERE clause is applied (if parent). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.
C.    HAVING clause is applied (if parent). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group

Right Answer: C

Que.8. What is the syntax for creation new login on the SQL server?
A.    USE LOGIN login_id WITH PASSWORD password
B.    CREATE LOGIN login_id WITH USE password
C.    CREATE LOGIN login_id USE password
D.    CREATE LOGIN login_id WITH PASSWORD password

Right Answer: D

Que.9. What is the purpose of MEARGE in sql server 2008?
A.    Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition
B.    Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that depends on a condition
C.    Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that independent on a condition
D.    Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that is independent on a condition

Right Answer: A

Que.10. SQL Server 2000 always returns the result of a FOR XML query directly to the client in XML form
A.    True
B.    False

Right Answer: B

Que.11. Dynamic Page Repair is a type of database mirroring.
A.    False
B.    True

Right Answer: A

Que.12. CPUs can dynamically be added to a running system, by using _________ feature
A.    Cold Add CPU
B.    Hot Add CPU
C.    Dynamic add CPU
D.    Passive add CPU

Right Answer: B

Que.13. The identifiers in SQL can have a character range from?
A.    1 to 100
B.    1 to 128
C.    1 to 64
D.    1 to 132

Right Answer: B

Que.14. Which of the following rules below are true to use the ROWGUICOL property to define a globally unique identifier column?
A.    A table can have only one ROWGUICOL column
B.    A ROWGULCOL column must not be defined by using the unique identifier data type.
C.    Both a and c
D.    NEWID function to generate a globally unique value.

Right Answer: A

Que.15. A column with an optimized storage for null values is known as ________ column
A.    spatial
B.    optimum
C.    dense
D.    sparse

Right Answer: D

Que.16. ______________ is a feature that is used for tracking the changes on a table
A.    Change schema Capture
B.    Change table Capture
C.    Change Data Capture
D.    Change database Capture

Right Answer: C

Que.17. ____________ helps to restore the database to the point where it failed.
A.    File backup
B.    Differential Backups
C.    File log
D.    Transaction log

Right Answer: D

Que.18. How do we delete a login?
A.    DLETE LOGIN login_name
B.    DROP LOGIN login_name
C.    A login cannot be deleted but only diabled
D.    DISABLE LOGIN login_name

Right Answer: B

Que.19. Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?
A.    System for managing the instance of SQL Server 2008
B.    SQL Server does not enforce to define the policies by using Management Studio
C.    Both b and d
D.    A policy can be designed for allowing the use of  unauthorized applications

Right Answer: C

Que.20. Remote BLOB storage is a _____________ API which reduces the application building complexity
A.    Server-side
B.    Client-side

Right Answer: B

CSS MCQ Test – 1

Que.1. A navigation bar needs standard HTML as a base
A.    True
B.    False

Right Answer: A

Que.2. The ____________ selector is used to specify a style for a single, unique element
A.    Id
B.    class
C.    text
D.    Bit

Right Answer: A

Que.3. Which of the following ways below is correct to write a CSS?
A.    p {color:red; text-align:center};
B.    p {color:red; text-align:center}
C.    p {color:red; text-align:center;}
D.    p (color:red;text-align:center;)

Right Answer:C

Que.4. The ____________ property specifies which sides of an element other floating elements are not allowed.
A.    cleared
B.    clear
C.    float
D.    Both A and B  above

Right Answer: B

Que.5. Which of the below is the correct way to set a background image?
A.    body {background-image:url(paper.gif);}
B.    body {background-image:url(‘paper.gif’)};
C.    body {background-image:url(‘paper.gif’)}
D.    body {background-image:url(‘paper.gif’);}

Right Answer: D

Que.6. The ___________ property specifies the stack order of an element
A.    d-index
B.    s-index
C.    x-index
D.    z-index

Right Answer: D

Que.7. Block elements can be aligned by setting the left and right margins to “align”
A.    True
B.    False

Right Answer: B

Que.8. Which of the below is the correct way to set a font size?
A.    h2{font-size:200%;}
B.    h2{font-size:200px;}
C.    both a and b above
D.    h2{font-size:200;}

Right Answer: C

Que.9. Elements in CSS cannot be positioned unless the positioning property is set first
A.    True
B.    False

Right Answer: A

Que.10. What is CSS Float?
A.    allows other element to wrap around an element
B.    element can be pushed to the left to right
C.    both a and b above
D.    element can be pushed to any direction

Right Answer: C

Que.11. To specify table border in CSS, ____________ property is  used
A.    tbl-border
B.    table-border
C.    tb-border
D.    border

Right Answer: D

Que.12. _________ property can be used to Increase or decrease the space between words
A.    space
B.    word-spacing
C.    word-space
D.    Both b and c above

Right Answer: B

Que.13. Multiple external style sheets cannot be referenced inside a single HTML document
A.    True
B.    False

Right Answer: B

Que.14. element-width property can be used to set the width of an element
A.    True
B.    False

Right Answer: B

Que.15. The _________ property is mostly used to remove underline from links
A.    text-trans
B.    text-transformation
C.    text-decoration
D.    text-deco

Right Answer: C

Que.16. Which of the following statements is TRUE for CSS
A.    An external style sheet is ideal when the style is applied to many pages
B.    An inline style sheet should be used when a single document has a unique style
C.    Both A and B above
D.    An external style sheet can be written in HTML

Right Answer: A

Que.17. Which of the following statements is/are true?
A.    Hiding an element can be done by setting the display property to “none”
B.    Hiding an element can be done by setting visibility property to “hidden”
C.    Both A and B above
D.    Hiding an element can be done by setting block property to “hidden”

Right Answer: C

Que.18. The font-size value can be an absolute, or relative size
A.    True
B.    False

Right Answer: A

Que.19. ______________ property specifies an image to use as the background of an element
A.    backg-img
B.    backg-image
C.    background-img
D.    background-image

Right Answer: D

Que.20. ID name should not start with a number
A.    False
B.    True

Right Answer: B