databases Online Quiz - 37
|Description: databases Online Quiz - 37|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which column is more skewed? Total no. of rows in the table are 1000
What is the limit on the size of a PL/SQL block?
What is the maximum PL/SQL code size?
Which of the following are the differences between SQL and PL/SQL?
Can you call a stored function in the constraint of a table ?
Which scenario below indicates HIGH cardinality column?
Can you change the inserted value in one of the columns in AFTER insert trigger code?
Why does a query in Oracle run faster when ROWID is used as a part of the where clause?
Which of the below are constructs of a procedure, function or a package ?
What is the maximum no.of statements that can be specified in a trigger statement ?
What is the maximum no of cascading triggers used at a time?
Which symbol preceeds the path to the table in the remote database ?
If all the values from a cursor have been fetched and another fetch is issued, the output will be :
Is Sysdate a system variable or a system function?
How can you avoid indexes ?
The variables or expressions referenced in the parameter list of a subprogram call are Actual parameters?
The variables declared in a subprogram specification and referenced in the subprogram body are formal parameters?
If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?
Which of the following is not a feature of a cursor FOR loop?
You want to access a SQL Server instance that is not in your domain. The only network protocol you can use is TCP/IP. Which ports do you need to open on the firewall that is between your computer and the server running SQL Server?